PDA

View Full Version : syncing files



joshua1990
11-17-2017, 01:48 AM
Hey guys!

I'm currently working with a big file/ tables. Some tables/ parts are not completely necessary for each user.
I would like to simplify/ minimize this file for the respective user.

As Example
Whole file = 10 tables
User 1= table 1-3
User 2 = table 2-3

The aim is, that these files are synchronizing in both ways.
If the user will change something in his own file, the mother/ parent file should sync this change or the other way.


Is this possible?
Is there any simple way or is this only possible with vba.


I'm grateful about every approach and idea.



Best regards

Logit
11-17-2017, 07:03 PM
.
It will require the use of VBA.

One method would be for each user to have a copy of the Table they use on their own machine. The MASTER FILE would reside on the server and periodically review the user files in order to update itself.

This method would eliminate the inherent issues involved with EXCEL's design creating issues for multi-users attempting simultaneous access to a MASTER FILE.