Hello everyone,
I just got a new job and i was asked to find a way to combine data from multiple workbooks into one master-sheet. New data will come all the time and i will need to update the master-sheet accordingly. I am new to this, but i was hoping to get your help please. I have been searching for a VBA formula which will help me accomplish this task but without success. I will receive a lot of data, and if i don't find the formula i will have to copy and past and that will be very hard.
This are the main points:
1. New data will come all the time
2. I will receive workbooks with data from different branches
3. I will have multiple rows and columns
4. Update the master-sheet
5. The old data on the master-sheet should not be deleted, only the new data should be included.
Your help is greatly appreciated. Thanks a lot,
Naski
I just got a new job and i was asked to find a way to combine data from multiple workbooks into one master-sheet. New data will come all the time and i will need to update the master-sheet accordingly. I am new to this, but i was hoping to get your help please. I have been searching for a VBA formula which will help me accomplish this task but without success. I will receive a lot of data, and if i don't find the formula i will have to copy and past and that will be very hard.
This are the main points:
1. New data will come all the time
2. I will receive workbooks with data from different branches
3. I will have multiple rows and columns
4. Update the master-sheet
5. The old data on the master-sheet should not be deleted, only the new data should be included.
Your help is greatly appreciated. Thanks a lot,
Naski
