If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
transfer of links
Hello all,
Here's the problem. I have 10 clubs. I receive 120 spreadsheets per week which is 12 each for 10 clubs. These hit my "C" drive. I then have 10 folders on the "C" drive relevant to the club. In each folder are another 6 spreadsheets that have links to the sheets on the "C" drive. What i want to do is update the 6 sheets in the folder for the sheets in "C" then archive the sheets in "C" somewhere else so that "C" does not get too big. How do i get the links in the sheets in the folder to follow the archived sheets? Can this be done by way of VBA? The clerks using the sheets are not confident at changing links manually. I hope i have explained myself clearly enough. Any help greatly appreciated. Cheers Joe Bannister |
#2
|
|||
|
|||
transfer of links
Joe Bannister wrote:
I hope i have explained myself clearly enough. I got a bit confused. It would be helpful if you could just talk about 1 file that you intend to move. Where is it moving from What files does it link to (including path)? Where is it moving to? Which version of Excel? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|