Copy an existing hyperlink to another cell
Closed
ShkeT
-
Jan 14, 2012 at 03:58 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 15, 2012 at 09:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 15, 2012 at 09:05 PM
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.
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.
Related:
- Copy an existing hyperlink to another cell
- Hyperlink in gmail - Guide
- Apply snapchat filter to existing video - Guide
- How to remove hyperlink in word - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 15, 2012 at 06:17 AM
Jan 15, 2012 at 06:17 AM
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
this is experience
=sheet1!a1
only copies the value (not hyperlink or formula)
copy paste(or pastespecial-all) does copy the hyperlink or formula
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 15, 2012 at 09:05 PM
Jan 15, 2012 at 09:05 PM
what is meant by "automatically" you can have a macro
a trivial example of macro is
even you have a button in sheet1 and if you click that button the macro is run
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
Jan 15, 2012 at 01:13 PM