วีดีโอ

@jasonclarkcarbon5456 : The code is below Sub test() Sheets("Data").Activate i = ActiveCell.Row Dim Sfirstname Dim Slastname Dim SRoll Dim Sclass Dim Smarks1 Dim Smarks2 Dim Smarks3 Dim Smarks4 Dim Smarks5 Sfirstname = Cells(i, 3).Value Slastname = Cells(i, 4).Value SRoll = Cells(i, 5).Value Sclass = Cells(i, 2).Value Smarks1 = Cells(i, 6).Value Smarks2 = Cells(i, 7).Value Smarks3 = Cells(i, 8).Value Smarks4 = Cells(i, 9).Value Smarks5 = Cells(i, 10).Value '*************************************************** Sheets("Report Card").Activate Cells(3, 3).Value = Sfirstname & " " & Slastname Cells(4, 3).Value = SRoll Cells(5, 3).Value = Sclass Cells(8, 4).Value = Smarks1 Cells(9, 4).Value = Smarks2 Cells(10, 4).Value = Smarks3 Cells(11, 4).Value = Smarks4 Cells(12, 4).Value = Smarks5 End Sub

Noted 👍

Glad to hear that

Thank you !

Glad it was helpful 😀

You can use Pivot tables for your case and try to achieve the desired result.

Glad to know it was helpful !

Thanks for the viewing & the feedback !

Thanks!

Glad that you learnt something new !

You are welcome!

This could be possible, although I havent tried it yet. :)

@NBH2023 - Please see the following video to see how a report card is generated th-cam.com/video/CvqjH0Ptk-k/w-d-xo.html

You're welcome

You are welcome !

@tanukadey : Thanks for the feedback.

@user-rn9mv7yz7h : This is a button in Microsoft Excel. To learn how to create and use a button, please view the following videos.

th-cam.com/video/noQp3C1IsQg/w-d-xo.html th-cam.com/video/DjiwjUWNNVg/w-d-xo.html

Thank you. Apparently, my Excel program is too old; it does not have the DEVELOPER etc tabs.@@ExceliburVideos

@RUTHVIKTEJASR - Yes, its completely free !

@Princess_Rojin : Thanks for watching the video. Please try Sheets("card").activate

Also, please check the following link for clarity on how buttons work in Excel th-cam.com/video/DjiwjUWNNVg/w-d-xo.html

Same issue!! I've written Sheets ("Card"). Activate But still it's showing in the same Data sheet..

You're welcome!

@johnson863 : The path of the PDF file is defined in the macro code. You are free to modify\define this path on your own. This will allow you to generate the report on the same path irrespective of the excel file.

@rramesh969 Use the code on the worksheet open event

Feedback noted

Thanks

Thanks!!

Glad to hear that!

Glad it helped

@britneybutler4191 : You can select muliple rows using a FOR loop in the code ( moving the desired row number in the variable "i" ). To generate multiple reports - you would need to copy-paste the "report card" sheet multiple times and then move the values of the variables otherwise all values get overwritten and you would only see the last row result

It definately works. Please try again and be careful with the syntax or code

You can definitely add photos in the survey. I havent tested whether these can be transfered diretly to google sheets \ excel ... will have a look

Sorry to hear that. Request you to please check the video & syntax again and try. It definately works :)

Thanks for the feedback. It will work with the Pivot table but it picks the data from the cell referenced in the code. While the Pivot table is dynamic, if you are able to get the right data in the right cells ... should work for you !

@@ExceliburVideos thanks 😊