I have a WB with multiple sheets with identical layouts, just the naame and data change.
I need to combine all sheets (about 30 or so) into 1 master sheet, but I also need to include the sheet name that the data came from - in a new column (A).
So...
copy all of sheet2 (A:N) to sheet1 B:O) and then enter "Sheet2" in column A in the corresponding rows
move to the next sheet, rinse and repeat for all sheets
I can dummy-up a sample WB if needed
Bookmarks