Linking/embedding worksheets
Hello. I have a ProjectManager Excel file with several (20) named sheets.
Then I have the 20 named files. (e.g. ProjectManager.xls with sheets named
DJ, Dale, Ed, etc... then the files DJ.xls, Dale.xls, Ed.xls, etc...)
I need to link/embed each named file to the corresponding sheet in the
ProjectManager file so when BossMan opens the main file (ProjectManager), all
the sheets are updated with the most current information.
Is this possible? Any help would be appreciated. Also, Microsoft Project
is not an option at the moment as we are over budget already. Thanks!!
|