View Full Version : [SOLVED] Multiple Excel sheets update

03-11-2017, 01:16 AM
So I have more a logical problem than a VBA problem.
I have four workbooks. Three are slave workbooks for my Sales reps, so that each Sales rep can work in his own workbook, open it, save it etc.. any time. The fourth is the MASTER workbook that is locked and controlled by me. It downloads the data from the other three workboks, sorts them, makes some graphs etc. But sometimes i find out that a sales rep has written total bull**** into his workbook. And here comes my question...
Is there a way that I can change data in the master workbook so that the change would also happen in the slave workbook? OR is this not possible in excel?

03-12-2017, 12:58 AM
No help needed, I solved the problem.

03-13-2017, 03:50 AM
Let me guess... you sacked the salesman?

03-13-2017, 02:39 PM
Nah, but I would like to...
Each entry had an special ID, I added two new columns to my data. Last time updated and who made the update of data. Now I download the data from slave books and slave books from me and data presented in Userform via Listbox is the data with newest list time updated time.