Copy an existing hyperlink to another cell

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Could you please advise how to solve the following problem.


I have in Sheet1, cell A1 a hyperlink to google.com
In Sheet2, cell A1 I copy the info from Sheet1, cell A1 (='Sheet1'!A1). But the hyperlink from Sheet1, cell A1 is not copied to Sheet2, cell A1.

Could you please advise how can I copy automatically the hyperlink?

Thank you in advance.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
this is not knowledge
this is experience

=sheet1!a1
only copies the value (not hyperlink or formula)

copy paste(or pastespecial-all) does copy the hyperlink or formula
So there is no way to do it automatically? :(
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
what is meant by "automatically" you can have a macro

a trivial example of macro is

Sub test()
Worksheets("sheet1").Range("a1").Copy Worksheets("sheet2").Range("a1")
End Sub


even you have a button in sheet1 and if you click that button the macro is run