Copying Hyperlinks to different sheets.

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

OK-

So I have set up an excel file with 50 different sheets (the states)
and they all share an identical structure with different data. I have
a hyperlink menu at the top of each sheet for all 5 of my major
headings (which are in the same cell on each sheet). I am able to
create the hyperlink menu with no problems at all. What I want to be
able to do is take that menu and copy and paste it to the next sheet.
The problem is that the hyperlink always shoots back to the original
sheet (that I copied from) but to the right cell number (wrong sheet).
I have tried creating a Macro but it always uses the original sheet
for the destination. Does anyone have any suggestions?

Thanks!
Steve
 
Trevor-

I created a macro, then edited that macro with VB and removed the
"Worksheet" references that way it just assumed the link was for that
page.

-Steve
 
Back
Top