JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
Unsure of the best way to approach this, it has to be with excel in some way.
Basically wanting to synchronise data input between 2 locations.
I was thinking maybe a MASTER workbook which stores data from WorkbookA and WorkbookB
A VBA module to store data in the MASTER then a refresh macro to reload data from it either side.
I know it sounds like a database job but I don't think that's an option
Any ideas?
Unsure of the best way to approach this, it has to be with excel in some way.
Basically wanting to synchronise data input between 2 locations.
I was thinking maybe a MASTER workbook which stores data from WorkbookA and WorkbookB
A VBA module to store data in the MASTER then a refresh macro to reload data from it either side.
I know it sounds like a database job but I don't think that's an option
Any ideas?