Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to update hyperlinks through multiple sheets but can't
I have 12 sheets which all incluce the same customer list pulling from a master list of customers. When I turn the master list of names into hyperlinks that go to their email, only the master list displays the link, and the other sheets which pull from the master list do not display the hyperlink. Also, if I try to select all sheets and change a name to a hyperlink, only the current sheet shows the hyperlink. How do I make it so when I turn the master list into hyperlinks, the list in the other sheets change into the hyperlink as well? Thanks. -- Billznik ------------------------------------------------------------------------ Billznik's Profile: http://www.excelforum.com/member.php...o&userid=37119 View this thread: http://www.excelforum.com/showthread...hreadid=568679 |
#2
|
|||
|
|||
I have searched several ways and found it for you. I think it will help you. You can try =HYPERLINK(""&Sheet1!A15&"") on the other sheets, not master sheet.
Sheet1!A15& is the address to the master sheet and cell, containing the hyperlink. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
Copyin multiple sheets data into one line | Excel Worksheet Functions | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
added line won't update accross sheets | Excel Discussion (Misc queries) | |||
selecting multiple sheets | Excel Worksheet Functions |