| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How will hyperlink cell reference update after copy paste?
When I hyperlink a cell and then copy paste it to another cell, the reference
still says the same. Is there a way for the cell reference to get updated just like the formulas? Example: Cell A1 is hyperlink to go to A72, when I copy A1 to T1, I want the hyperlink to go to T72 but it still goes to A72. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How will hyperlink cell reference update after copy paste?
Something like:
=HYPERLINK("#"&CELL("address",Sheet3!A72),"target is relative") will adjust. -- Gary''s Student - gsnu200852 "bjry" wrote: When I hyperlink a cell and then copy paste it to another cell, the reference still says the same. Is there a way for the cell reference to get updated just like the formulas? Example: Cell A1 is hyperlink to go to A72, when I copy A1 to T1, I want the hyperlink to go to T72 but it still goes to A72. Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How will hyperlink cell reference update after copy paste?
Thank you very much! This will save me a lot of time.
"Gary''s Student" wrote: Something like: =HYPERLINK("#"&CELL("address",Sheet3!A72),"target is relative") will adjust. -- Gary''s Student - gsnu200852 "bjry" wrote: When I hyperlink a cell and then copy paste it to another cell, the reference still says the same. Is there a way for the cell reference to get updated just like the formulas? Example: Cell A1 is hyperlink to go to A72, when I copy A1 to T1, I want the hyperlink to go to T72 but it still goes to A72. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink Copy & Paste | Excel Discussion (Misc queries) | |||
| Copy & Paste Forumla - but reference cell is changing | Excel Discussion (Misc queries) | |||
| copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
| hyperlink copy / paste | Excel Discussion (Misc queries) | |||
| Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
Linear Mode
