I had an idea... in my company there are several stand-alone contact lists each one managed with a separated Excel file. These directory of contacts are in several cities for that I had that idea:
create a master directory excel sheet managed by the HQ and populate it with all the other "branch" files uploaded on Google Drive or any other Web space by the users.
What the VBS or macro should do is anytimes I open the master document, it must look inside the path where the files have been uploaded then one by one import in into the master doc by creating the sheets inside each one.
Which one is the way to do that?
Edited by hamluis, 03 October 2015 - 11:39 AM.
Moved from Programming to Business Apps - Hamluis.