Macro for Consolidation of Info from Different Tabs

C

cardan

Hello,

I have an excel file with different worksheets that contain tables of
data that are imported from other sources on a month to month basis.
I would like to be able to have a macro that will populate a "master
sheet" (with no spaces) that will contain all the data from all these
worksheets. The problem is that each time the data is imported to
Excel, the amount of data grows and formulas would not be the best
answer since the amount of info on each worksheet keeps growing and
would have to be redone every time.

Any help would be greatly appreciated. Thank you for your time
 

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

Macro for Consolidation of Info from Different Tabs 1
Macro to Compile Data from Different Sheets 2
Dynamic Array for data consolidation 2
Importing several web pages with macro/VBA? 9
Data Extract from Multiple Worksheets Macro 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using xlsm worksheets on different computers 5
Alternative way to show 12 tabs?? 5

Top