It made sense to me at the outset.
I just questioned why couldn't any one of the WBs simply be "Saved" after a
revision, and then click on "Save As", and save it to the name of the
*other* file.
That gives you two exact WBs.
This would be a very simple macro that could be recorded and placed on the
toolbar.
Do it for each WB.
Another option, that I use extensively at my plant, is having only one
original file, but have many "shortcuts" installed in numerous other
locations.
This is not *exactly* like an XL link, where two files are connected.
This is one file, with many "doors" into it, where the "doors" (shortcuts)
can be created in any location, as long as these locations are accessible to
all the machines concerned, such as a LAN file server.
This is accomplished by using Windows Explorer.
Open explorer and navigate to the original file in question, and have it
visible in the right pane.
Scroll the left pane to make the target file (folder) visible.
Now, *RIGHT* click and drag the original from the right pane to the target
folder in the left pane.
When you release the right mouse button, you will see a menu, usually with
three options, one of which is "CreateShortcuts".
Choose this option, and you will then find this file in the target folder
displayed with a small arrow in the lower left, similar to what you might
see in numerous file icons on your Windows desktop.
You can create as many of these as you wish, but keep in mind, there is
*only one* file in existance.
Open it from any of the locations that you created, knowing that you are
opening the *original*.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Yes, the same workbook in two separate files. For example, we keep an
electronic file index of project drawings in a path that starts with "Dwg
Indexes", and we also have individual project files in a path that starts
with "Project Files". While some folks may go to the "Dwg Indexes" to find
the file for a specific project, some would prefer to go to the individual
project file to find everything that pertains to that project, including the
drawing index. My intent was to have the drawing index in both places,
updating each other as new info is added, no matter which file the addition
was made to. Make sense now?
