Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate data to summary sheet
I'm sure this is an easy task, but I'm not sure where to start.
I have a workbook with a number of worksheets. The number of sheets will increase over time. I need to produce a sheet combining certain columns from all the other sheets. How can I do this? eg On sheet "Summary", starting on row 2 I need the data from sheet "John Smith" columns A:D row 2 to the last occupied row. Under this data on "Summary" I need the equivalent data from sheet "Tom Jones" etc. I hope this is clear. -- Ian -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate data to summary sheet
for each sht in Thisworkbook.sheets if sht.name < "Summary" then SumLastRow = Sheets("Summary").Range("A" & Rows.Count).end(xlup).Row SumNewRow = SumLastRow + 1 ShtLastRow = sht.Range("A" & Rows.Count).end(xlup).Row sht.Range("A2:D" & ShtLastRow).copy _ destination:=Sheets("Summary").Range("A" & SumNewRow) end if next sht "Ian" wrote: I'm sure this is an easy task, but I'm not sure where to start. I have a workbook with a number of worksheets. The number of sheets will increase over time. I need to produce a sheet combining certain columns from all the other sheets. How can I do this? eg On sheet "Summary", starting on row 2 I need the data from sheet "John Smith" columns A:D row 2 to the last occupied row. Under this data on "Summary" I need the equivalent data from sheet "Tom Jones" etc. I hope this is clear. -- Ian -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Multiple sheet data summary | Excel Worksheet Functions | |||
Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
Display summary sheet with Now or Today data. | New Users to Excel |