How to proceed with consolidation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Ron,
As always, thanks! However, I was hoping to avoid using a macro altogether.
Regards,
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Numbers 12
Consolidate an XLS sheet 3
Need macro to consolidate all sheets in workbook 1
Consolidate CSV files with historical returns for stocks in onespreadsheet 1
Consolidated array 3
Linking multiple sheets to one master 5
Problem with consolidation 0
Copying data from one workbook to another dependent on user select 1

Back
Top