Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hyperlinks
Hi
I have created a hyperlink on a worksheet using the formula =HYPERLINK(BB1,BR1) this creates the hyperlink no problem what i want to do is copy the hyperlink from one worksheet to another worksheet when i try this i only manage to get the text value to paste can anyone please tell me how to copy and paste a hyperlink ? thanks in advance kevin |
#2
|
|||
|
|||
Hi
should the copied Hyperlink still reference the old source cells? "Kevin" wrote: Hi I have created a hyperlink on a worksheet using the formula =HYPERLINK(BB1,BR1) this creates the hyperlink no problem what i want to do is copy the hyperlink from one worksheet to another worksheet when i try this i only manage to get the text value to paste can anyone please tell me how to copy and paste a hyperlink ? thanks in advance kevin |
#3
|
|||
|
|||
Frank
thankyou for your reply The copied Hyperlink should not reference the old source cell kevin |
#4
|
|||
|
|||
Hi
so you only want to copy the hyperlink information? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ups.com... Frank thankyou for your reply The copied Hyperlink should not reference the old source cell kevin |
#5
|
|||
|
|||
Frank
I want to copy the actual hyperlink from one workshet to another and have the hyperlink work on the second worksheet, targeting the hyperlink address not the original cell it was copied from. thanks kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks from one document to another document on a different dr | Charts and Charting in Excel | |||
Keyboard shortcut to follow hyperlinks? | Links and Linking in Excel | |||
Excel hyperlinks without screen tips | Excel Discussion (Misc queries) | |||
Relative Hyperlinks to PDFs (or other documents) | Excel Discussion (Misc queries) | |||
Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) |