Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
Hyperlinks and Named Ranges | Excel Discussion (Misc queries) | |||
Need macro to copy a list of named cells between worksheets | Excel Worksheet Functions | |||
zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
copying cells from other worksheets | Excel Discussion (Misc queries) |