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.

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.

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.