aeolianje
asked on
Combine Excek worksheets
I maintain weekly time reporting worksheets (within a single Excel file) and want to combine them into one worksheet in order to summary information over the year.
The column headings from each sheet are consistent.
I would like to capture the sheet name as a new column in order to differentiate the data once combined.
Attached is a sample.
Thanks for your help,
je
Weekly-Activity-Tracking---sampl.xls
The column headings from each sheet are consistent.
I would like to capture the sheet name as a new column in order to differentiate the data once combined.
Attached is a sample.
Thanks for your help,
je
Weekly-Activity-Tracking---sampl.xls
ASKER
I would like the contents of each sheet included in the summary sheet -- with an extra column indicated which sheet it came from. Attached is a sample spreadsheet showing the "Year End Summary" spreadsheet resulting from the code -- and a 'Desired Results' spreadsheet showing what I'm really looking for. Hope that clarifies.
Thanks,
je
Macro-test.xlsm
Thanks,
je
Macro-test.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is perfect!!!! Thanks so much for your help.
je
je
Open in new window