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]

cross post
http://www.excelforum.com/excel-prog...ng-report.html

[Aussiebear]

Hi vradhak7, any other forums you might have cross posted in but forgot to point out here?

[vradhak7]

Aussiebear...No sir!

[p45cal]

Aussiebear...No sir!

http://www.ozgrid.com/forum/showthread.php?t=191275

[Aussiebear]

Hmmm.... lets say, I'm in a really good mood, and the Ozgrid.com one doesn't count, any others out there that we should not count as well?