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