I've got a big tasks awaiting me at work.
I have 100 cost centers. Each manager reporting to me must evaluate their cost centers and explain variances between actuals and budgets. They must develop action plans to rectify any unfavorable variances. Each file contains multiple links to files on a network drive that shows actual data. All of the links have been placed on a menu page. There are about 50 links.
I created a template file for the first cost center. I must duplicate this file for each cost center. My problem is this, I must update the links for each cost center so that they point to the appropriate data. The files to which the links post are different for each cost center.
Example of file name located on network drive:
t:/departments/2313/cost_center_2313-variance _FY2005_Period01.xls
Example of file for another cost center (only directory and file name changes):
t:/departments/3225/cost_center_3225-variance _FY2005_Period01.xls
Is there any way to automate the creation of each new cost center's file with the new links? Or, is there anyway to edit these hyperlinks without having to "edit" each hyperlink individually?
Scott
Houston, TX
I have 100 cost centers. Each manager reporting to me must evaluate their cost centers and explain variances between actuals and budgets. They must develop action plans to rectify any unfavorable variances. Each file contains multiple links to files on a network drive that shows actual data. All of the links have been placed on a menu page. There are about 50 links.
I created a template file for the first cost center. I must duplicate this file for each cost center. My problem is this, I must update the links for each cost center so that they point to the appropriate data. The files to which the links post are different for each cost center.
Example of file name located on network drive:
t:/departments/2313/cost_center_2313-variance _FY2005_Period01.xls
Example of file for another cost center (only directory and file name changes):
t:/departments/3225/cost_center_3225-variance _FY2005_Period01.xls
Is there any way to automate the creation of each new cost center's file with the new links? Or, is there anyway to edit these hyperlinks without having to "edit" each hyperlink individually?
Scott
Houston, TX