Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Smile Updating hyperlinks on multiple sheets

Hello,
I am working on a speadsheet where I want each sheet to link to a specific cell in that sheet.

Question 1: Is there a quick way to do this besides 'Right Click- Hyperlink- Place in the Doc- Select Cell- Cell Reference"?

Question 2: I need to do this for each sheet and use the same cell, but change the name of the sheet.

For example, I want cell I7 to link to A519, I8 to link to A554, etc. on a sheet called Healthcare and then I want the same cells in a sheet called Beauty to link to the same cells within the Beauty sheet. The cells (I7, I8, etc.) are formulas so I can't use Find/Replace. All of the cells reference other cells within the same sheet (All Healthcare to cells on the Healthcare sheet, all Beauty to cells on the Beauty sheet).

Is there a way to change all of 'Healthcare' to 'Beauty' without changing what cell it is referencing? I tried a Macro, but it changed the cell referenced as well.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to update hyperlinks through multiple sheets but can't Billznik Excel Worksheet Functions 1 February 28th 12 07:19 AM
Updating a Formula Based on Multiple sheets aks1983 Excel Worksheet Functions 6 May 5th 09 10:43 AM
Simultaneously updating Charts in Multiple sheets J Shrimps, Jr. Excel Worksheet Functions 1 April 23rd 06 05:13 AM
repost; Automatically updating formulae in multiple sheets Keith Nicholls Excel Discussion (Misc queries) 1 January 5th 06 04:39 AM
Updating Excel Data on Multiple Sheets Juana Cafe Excel Worksheet Functions 3 February 28th 05 10:04 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"