I have multiple project reports which each have a number of tabs/sheets. eg. a, b, c, d, e, [url removed, login to view] reports will all be dropped or stored in a folder on the network drive. Eg 'Project Reports Week Ending 1/07/2011'
On a separate Program report (which will be stored in a sub folder, within the 'Project Reports Week Ending 1/07/2011' folder) i want a macro to be written on the front sheet that will capture the first sheet of each of the project reports that are dropped into the folder, and put them in the tabs of the program report.
For Example, i'll name all 5 reports
and the Program Report 6.
and name the sheets for each Report
Therefore i have
1A, 1B, 1C, 1D, 1E,
2A, 2B, 2C, 2D, 2E
6A, 6B, 6C, 6D, 6E, 6F.
and so on
I want it as below on Program Report 6.
6A (that contains the macro), 1A, 2A, 3A, 4A, 5A
I want The format to be kept the same, so if it is changed in Project Report 1, It will stay the same in the Program Report.
I'll be paying $30 only, and will be paying once i know the macro works. I will also need additional support, as i need to submit this to someone.
I would also like to see some examples.
Please no time wasters.