Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Value Update during COPY
I have created a Master worksheet that has links to another master worksheet.
Serveral hundred cells with the link. When I need to create a useable copy, I copy both worksheets from the Master. I need to FIND AND REPLACE all the names in order to replace the actual worksheet names for the proper links. Unfortunately it requires me to respond after each cell change to UPDATE the new Source (Link). This is really time consuming. It is, by the way, the same worksheet link thoughout the copied worksheet. Is there a way I only have to respond once for the entire FIND AND REPLACE routine instead of during each cell change? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy two linked sheets, and update the link isn't to the previous | Excel Discussion (Misc queries) | |||
Update link value | Excel Worksheet Functions | |||
Drop Down--How do I copy and update cell link/input range | Excel Discussion (Misc queries) | |||
Don't update link | Excel Discussion (Misc queries) | |||
update a link to a CSV | Excel Discussion (Misc queries) |