Copying Hyperlinks that automatically update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try to use menu item Edit | Find and Replace to replace

[c:\My Documents\OtherExcelFile.xls]SheetX!

with

Sheet1!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with hyperlinks 2
Copy hyperlinks 6
Macro to Combine Data from Multiple Sheets with Cell References 4
Progressive number in different sheets 7
Copy adjacent Sheet and name from a list 42
Run two macros for two different sheets 11
Search , then copy and paste from multiple worksheets. VBA help 1
Copy Template with Updated Values Each Time 0

Back
Top