PDA

View Full Version : [SOLVED] Multiple Excel sheets update



DavidWaldo
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?

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

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

DavidWaldo
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.