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
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