Hi all.. My first post here.. I need your help. I have a folder with hundreds of reports. Each report has the report name in cell A1 and all the column headers in row 4 (normally from A4 - CR4 but this can vary). I am trying to create a data sheet for all the column headers for each report which would look like this :
Column A Column B
Column 1 Name Report 1 Name
Column 2 Name Report 1 Name
.
.
Column N Name Report 1 Name
Column 1 Name Report 2 Name
Column 2 Name Report 2 Name
....
Column N name Report N Name
Your help is really appreciated..
Is it something that can be done without knowing the exact number for reports or column numbers?
Column A Column B
Column 1 Name Report 1 Name
Column 2 Name Report 1 Name
.
.
Column N Name Report 1 Name
Column 1 Name Report 2 Name
Column 2 Name Report 2 Name
....
Column N name Report N Name
Your help is really appreciated..
Is it something that can be done without knowing the exact number for reports or column numbers?
