Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a workbook with 50+ worksheets that have data in the exact same place and format. I would like to take the contents of each worksheet and consolidate it into a single worksheet, working downwards. For example, the data in all sheets is found in A1:C3. I would like this consolidated worksheet to have the contents of sheet one be in the same A1:C3, but sheet two's data would go directly underneath, into cells A4:C6, sheet three's data into cells A7:C9.... and so on. Note: 1. The number of original worksheets could grow from 50 to 100 2. The consolidated data could be a new workbook, a new worksheet, or on the first worksheet Thanks a lot in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros for Consolidating data in worksheet 1 on worksheet 2 | Excel Programming | |||
consolidating data in an excel worksheet | Excel Discussion (Misc queries) | |||
Consolidating Sales Data to Summary Worksheet | Excel Worksheet Functions | |||
Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming | |||
Help with worksheet consolidating | Excel Programming |