| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Hyperlinks that automatically update
I have two worksheets with over 30 links between the two sheets. I have
copied these two sheets together to make 12 sets. However, the hyperlinks are still linking to the original second sheet. Sheet 1 Cell linked to a cell on Sheet 2 I made copies of these two sheets Now I want to update the Hyper links in the new sheets so that Sheet 1(copy) cell will link to the proper Sheet 2 (copy) cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying Hyperlinks that automatically update
try to use menu item Edit | Find and Replace to replace
[c:\My Documents\OtherExcelFile.xls]SheetX! with Sheet1! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
| Update a chart using Hyperlinks | Charts and Charting in Excel | |||
| Update one cell with many hyperlinks | Excel Discussion (Misc queries) | |||
| Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
| Copying (Master) column to another sheet to automatically update | Excel Worksheet Functions | |||
Linear Mode
