Generate Automatic Reports in Excel

[@jasonclarkcarbon5456]

Need the code

[@ExceliburVideos]

@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

[@abdirahmanawil7096]

Thanks, and by the way this Video is very under rating.

[@RavindraSingh-pr3rt]

Great vedio, Keep up the good work

[@ExceliburVideos]

Thanks!

[@FadhiliHazenphosemalima]

This is nice

[@ExceliburVideos]

Thanks

[@judithsjc6578]

Thank you Sir 🙏

[@Rojin.Marzooki]

I followed the instructions, but the data was entered in the cells of the same sheet not in the second sheet although iam sure that i wrote activate the second sheet. What is the problem
I wrote: sheet(“card”).activate
But nothing was written in it
It was written in the data sheet cells…. But also you didn’t show how you connected the code to the button. I did insert command button and added the code to when click on it

[@ExceliburVideos]

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

[@ExceliburVideos]

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

[@SamSam_249]

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

[@ShivanandShindhe]

in case of different subjects for some students how to show it in report

[@ExceliburVideos]

If you need multiple students, you can run a FOR loop and data for all the students can be picked. The report format needs to be adjusted accordingly.

[@fitrixaini2916]

@@ExceliburVideos can you do some tutorial about that? Thank you🙌🏻

[@mudarsaid9733]

Hey thanks ... great video... i have question is it applicable for pivot tables as well.
You noy pivot tabels are dynamic. Though the row keep changing when we filter. Do you know if it still works ?

[@ExceliburVideos]

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 !

[@mudarsaid9733]

@@ExceliburVideos thanks 😊

[@tapan4253]

Hello i want to know about, i have one table and that table have 500 to 600 value , so agar me ek insert button banana chahta hu agar for example mene upr name likha rakesh to uske samne uski details aa jae jo us table me ho, muje esa ek excel sheet banani hai kyoki value bhot sari hai search krne me time lgta hai so

[@ExceliburVideos]

Hi, as I understand, in this case you need to search\compare a value in a given data-set. You can watch the following video which is based on the same principle :
th-cam.com/video/oAeZ5Ow5UOY/w-d-xo.html

[@britneybutler4191]

How can I highlight multiple rows and generate multiple reports on multiple sheets at once?

[@ExceliburVideos]

@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

[@user-rn9mv7yz7h]

Where did you get the little window that says "Generate Report"

[@ExceliburVideos]

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

[@ExceliburVideos]

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

[@user-rn9mv7yz7h]

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

[@rirox9196]

Thank you Sir 🙏