creating report

[vradhak7]

Hello Vba Gurus,
I am relatively new to VBA. I want to create a create a report based on the input/raw data that I have. Since it is quite complex to explain, I have attached an excel file. It consists of 3 input data sheets(Data, Course details,Actual Date) from which I have to gather or lookup data. The "Output" sheet is the way i want the macro to create the results.Your help would be greatly appreciated.

Note:
Column J of "Data" sheet should be gathered from Column A of "Actual Date" sheet.
Row(1,2,3) of "Output" sheet is to be gathered from "Course Details" sheet.

I want this report to be Dynamic as I will be run the macro after entering new data.There could be more number of classes and dates which I would be entering. What would be the best way to do this?


Your expertise and insights would be of great help. Thank you in advance.

I am attaching the excel sheet for reference.

Regards
Vradhak7excel.xlsx

[jolivanes]

vradhak7
Please read the forum rules regarding cross posting.
http://www.vbaexpress.com/forum/show...reating-report
In all forums where you have cross posted, let them know, like I did here, where you have done this.

[vradhak7]

sure jolivanes! thank you for the info