Mc Culloch
Board Regular
- Joined
- Jul 21, 2005
- Messages
- 68
Hi
Have a workbook with 27 sheets in it. Each sheet is for a department code.
Fortuately the data on each sheet is in the same range, A6:S148. I'm looking for a quick way to copy the range from each sheet and stack them below each other in a master table, along with the Dept code (which is always in cell A2.
Any suggestions most welcome. I'vve been getting bogged down in how to loop through the worksheets and also, once on the Master sheet, how to move the active cell one row down having done End:xl down so that I don't over write the previous sheets last row of data - in fact I'm just bogged down!
Cheers
Have a workbook with 27 sheets in it. Each sheet is for a department code.
Fortuately the data on each sheet is in the same range, A6:S148. I'm looking for a quick way to copy the range from each sheet and stack them below each other in a master table, along with the Dept code (which is always in cell A2.
Any suggestions most welcome. I'vve been getting bogged down in how to loop through the worksheets and also, once on the Master sheet, how to move the active cell one row down having done End:xl down so that I don't over write the previous sheets last row of data - in fact I'm just bogged down!
Cheers