Copying worksheets with hyperlinks to named cells
 

I have a spreadsheet that I am working to collect data for several different
products. I developed a skeleton worksheet that will be copied within the
same workbook and re-named with each individual product. In the skeleton
sheet, I have hyperlinks near the front of the sheet that reference to areas
later in the sheet (via named cells).

I copied this skeleton sheet and gave the copy another name ('product 1' for
example). When I click the hyperlinks in the 'product 1' worksheet, it links
back to the 'skeleton' worksheet.

Is there an easy way to have the links transferred and referenced to the
'product 1' sheet without editing or re-referencing each one on each copied
sorksheet?

We currently are using Excel 2003.

Thank you for your time,
Teri

Copying worksheets with hyperlinks to named cells
 

Hi Teri,

The following link will change accordingly if you insert/delete
rows/columns:
=HYPERLINK("#"&CELL("address",C5),C5)

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Teri Miller" <Teri wrote in message ...
I have a spreadsheet that I am working to collect data for several different
products. I developed a skeleton worksheet that will be copied within the
same workbook and re-named with each individual product. In the skeleton
sheet, I have hyperlinks near the front of the sheet that reference to areas
later in the sheet (via named cells).

I copied this skeleton sheet and gave the copy another name ('product 1' for
example). When I click the hyperlinks in the 'product 1' worksheet, it links
back to the 'skeleton' worksheet.

Is there an easy way to have the links transferred and referenced to the
'product 1' sheet without editing or re-referencing each one on each copied
sorksheet?

We currently are using Excel 2003.

Thank you for your time,
Teri