joelle
03-23-2006, 09:50 AM
Hello Experts,
Now I have an ongoing project of having to synchronizing different spreadsheet to a master one everyday and so if you could shed some light I'd sure appreciate it tremendously.
Case: I have a master workbook (says 3 worksheets there) and I send a copy out to Sales. Then, each of them will fill in sales info and send it back to me; there are 20 ws that I need to look at one by one and type in the new info onto my master spreadsheet.
Is there a simple VBA to do this task??? And I'd like the sync data to be added to the master (to empty fields there) and not override the existing data in the master wb.
Thanks so much in advance (I attach here an example wb).
Nee
Now I have an ongoing project of having to synchronizing different spreadsheet to a master one everyday and so if you could shed some light I'd sure appreciate it tremendously.
Case: I have a master workbook (says 3 worksheets there) and I send a copy out to Sales. Then, each of them will fill in sales info and send it back to me; there are 20 ws that I need to look at one by one and type in the new info onto my master spreadsheet.
Is there a simple VBA to do this task??? And I'd like the sync data to be added to the master (to empty fields there) and not override the existing data in the master wb.
Thanks so much in advance (I attach here an example wb).
Nee