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:
Thank you very much for your help.
Kind regards,
Erika
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