I have multiple worksheets my group uses that rely on data from a single control list that must be updated periodically, sometimes weekly. I want to have the worksheets dependent on that list automatically import the data each time the document is opened after it confirms the document is reachable. I know of a similar application using an .ini file, but I'm curious if I can easily do something similar with another Excel worksheet on a shared network store.
The imported data will be used in various VLOOKUP functions in the worksheet, with multiple columns of data.
Thanks in advance for a little direction here.
Bookmarks