PDA

View Full Version : creating report



vradhak7
10-05-2014, 05:40 PM
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
Vradhak712362

jolivanes
10-05-2014, 08:45 PM
cross post
http://www.excelforum.com/excel-programming-vba-macros/1041460-creating-report.html

Aussiebear
10-05-2014, 11:28 PM
Hi vradhak7, any other forums you might have cross posted in but forgot to point out here?

vradhak7
10-06-2014, 06:20 AM
Aussiebear...No sir!

p45cal
10-06-2014, 07:02 AM
Aussiebear...No sir!http://www.ozgrid.com/forum/showthread.php?t=191275

Aussiebear
10-06-2014, 07:29 PM
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?