VBA Gather data from multiple files and sheets

erikavb04

New Member
Joined
Jun 23, 2016
Messages
2
Hello,

Every month I get an update of data which is given in different files and sheets (see files "DataFile01 & DataFile02").
What I always do, is that I gather them in 1 table (see file "DataTableResults").

See files:
https://drive.google.com/open?id=0B00gFmdiXOT4NnlHcGVlOG5PTUE

I have always done it manually which takes me a lot of time, now I would love to let it run automatically.
Can someone help me with this pls?

When gathering the data, the following things should be taken into account:
  • Amount of tabs vary per file
  • Amount of data length (total rows) vary per sheet
  • When pasting all this data into 1 table, it should always overwrite the existing data in the table

Thank you very much for your help.

Kind regards,
Erika
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

erikavb04

New Member
Joined
Jun 23, 2016
Messages
2
Hi AlphaFrog,

Thank you for the fast reply, the Excel Merge Add-in is amazing!
Very nice tool of Mr. de Bruin, it will perfectly do the job :).

Thanks again.
Erika
 

Watch MrExcel Video

Forum statistics

Threads
1,123,517
Messages
5,602,117
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top