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.

[@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
ua-cam.com/video/DjiwjUWNNVg/v-deo.html

[@SamSam_249]

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

[@RavindraSingh-pr3rt]

Great vedio, Keep up the good work

[@ExceliburVideos]

Thanks!

[@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🙌🏻

[@DS-cf1zc]

How easy would it be to extend the report card function to say produce an automated paragraph that sets out how the student is performing -
So as means of an example. Using the Sorabh example in the video
We have found that Sorabh has performed well in Physical Education, Maths and Hindi, but could focus on improving English and Science.
So the paragraph is contextualised to what the report card is showing - Do you have any ideas?

[@ExceliburVideos]

@DS-cf1zc : Thanks for watching the video and conceptualizing the further ideas. What you suggest is surely possible. Using a code in the script , you can easily identify by comparison, the weak subjects ( lets say score below 60 ) and in the end create a message box or write a text in a cell what you desire. The text will be majorly static and only the subjects can be variable which come out from the comparison function

[@DS-cf1zc]

@@ExceliburVideos Thank you - have you got a video of how you could do this - or could you put together one that shows me how it could be done?
I think once i have seen one way of doing it - I suspect I could adapt it.

[@ExceliburVideos]

@DS-cf1zc : please add this code (tested) . Its just a basic code but can be improvised and improved further :
Dim a,b,c,d,e
If Smarks1 < 60 Then
a = "English"
End If
If Smarks2 < 60 Then
b = "Hindi"
End If
If Smarks3 < 60 Then
c = "Science"
End If
If Smarks4 < 60 Then
d = "Maths"
End If
If Smarks5 < 60 Then
e = "PE"
End If
Cells(15, 3).Value = "Student needs improvement in : " & a & " " & b & " " & c & " " & d & " " & e

[@DS-cf1zc]

@@ExceliburVideos Thank you I will try experimenting with it - legend.

[@ExceliburVideos]

Thank you too ! Have fun :)

[@FadhiliHazenphosemalima]

This is nice

[@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 :
ua-cam.com/video/oAeZ5Ow5UOY/v-deo.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

[@MaurineRamos-k1e]

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]

ua-cam.com/video/noQp3C1IsQg/v-deo.html
ua-cam.com/video/DjiwjUWNNVg/v-deo.html

[@MaurineRamos-k1e]

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

[@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 😊

[@rirox9196]

Thank you Sir 🙏