| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple ranges into one worksheet
I have 5 data ranges on different worksheets that I need to combine into the
one worksheet for analysis purposes. The ranges are formatted in the same columns but differing row lengths and the row lengths may expand on a monthly basis. Consolidation and pivot tables with multiple ranges are not working for me. I have no knowledge of VBA at this stage. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine multiple ranges into one worksheet
Hi,
You should take a look at the Data, Consolidate command. If the first row and first column have unique identifiers you can consolidate by using them. Look this topic up in the help system to see if it meets your needs. -- Thanks, Shane Devenshire "Troy Man" wrote: I have 5 data ranges on different worksheets that I need to combine into the one worksheet for analysis purposes. The ranges are formatted in the same columns but differing row lengths and the row lengths may expand on a monthly basis. Consolidation and pivot tables with multiple ranges are not working for me. I have no knowledge of VBA at this stage. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple sheets of data into one worksheet | Excel Discussion (Misc queries) | |||
| How do I combine multiple worksheets into one worksheet? | Excel Worksheet Functions | |||
| Printing multiple ranges on one worksheet | Excel Discussion (Misc queries) | |||
| Combine contents of multiple workbooks into one worksheet | Excel Worksheet Functions | |||
| Multiple Print Ranges on one Worksheet | Excel Worksheet Functions | |||
Hybrid Mode
