| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to proceed with consolidation
I have a workbook with 5 tabs: North, South, East, West, and Summary.
Although the number and structure of the columns is the same on all 5 tabs, the number of rows varies on the first 4 tabs. I need to periodically consolidate the data on the first 4 tabs over to the Summary tab, and ideally, I would like the consolidation process to occur automatically. Can someone tell me the BEST way to proceed? I'm not sure if I should be using Lists, Microsoft Query, or some other approach. Any guidance would be greatly appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to proceed with consolidation
Hi Bob
For a macro solution look here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a workbook with 5 tabs: North, South, East, West, and Summary. Although the number and structure of the columns is the same on all 5 tabs, the number of rows varies on the first 4 tabs. I need to periodically consolidate the data on the first 4 tabs over to the Summary tab, and ideally, I would like the consolidation process to occur automatically. Can someone tell me the BEST way to proceed? I'm not sure if I should be using Lists, Microsoft Query, or some other approach. Any guidance would be greatly appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to proceed with consolidation
Ron,
As always, thanks! However, I was hoping to avoid using a macro altogether. Regards, Bob "Ron de Bruin" wrote: Hi Bob For a macro solution look here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a workbook with 5 tabs: North, South, East, West, and Summary. Although the number and structure of the columns is the same on all 5 tabs, the number of rows varies on the first 4 tabs. I need to periodically consolidate the data on the first 4 tabs over to the Summary tab, and ideally, I would like the consolidation process to occur automatically. Can someone tell me the BEST way to proceed? I'm not sure if I should be using Lists, Microsoft Query, or some other approach. Any guidance would be greatly appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consolidation | Excel Discussion (Misc queries) | |||
| not sure how to proceed | Excel Worksheet Functions | |||
| consolidation | Excel Discussion (Misc queries) | |||
| Consolidation | Excel Discussion (Misc queries) | |||
| Is there a way I can enter a letter to proceed text a column of ce | Excel Discussion (Misc queries) | |||
Linear Mode
