I have a Excel data sheet that I pull data from and analyze with other data sheets
The data sheet has a date used in the header of the columns that I want to use in the final summary, however it is not located on the first row (it is a formatted table that starts the data a few rows down)
(data source #1)
Data sheet 2 (GL detail)
I want to create a summarized table that uses the date headers from the first data sheet with GL detail from another data sheet
(Column F will be a calculation from the first sheet, column G will be the summed totals from the second sheet.
That way anytime I insert a new file into the workflow, the dates will appear
The biggest thing I struggle with is getting the date headers from the first sheet when it is located on the 4th row of the excel file.
Thanks,
Todd
