Mirror/copy cells containing hyperlink within workbook

[nrj774]

Hi, I need to mirror/copy a cell which is an external hyperlink, to different cells in tabs within the same workbook.
The mirrored cells also need to be hyperlinks and automatically change when the master cell Hyperlink is updated. If I use copy and paste the cell contents are copied but not the hyperlink. Is there a way of achieving this?

[kev_]

Welcome to the board
Here is one way using a formula and VBA

Insert this function in a VBA module

Please Login or Register  to view this content.

Put this formula (amended as required) in the cells where the link needs replicating

Please Login or Register  to view this content.

The link in cell containing the formula is updated whenever A1 in sheet "Sheet Name" is amended

Remember to save the workbook as macro enabled

[nrj774]

Thanks for the help Kev. I’ll try the formula solution and update as to how I get on.

[kev_]

VBA can be avoided if the source cell value is the hyperlink address

So if A1 in source sheet contains .. "http://www.google.com"

use this formula in other sheets
=HYPERLINK('Sheet Name'!A1,'Sheet Name'!A1)

No requirement to copy anything, the formula updates automatically when hyperlink address is updated

This may help you if unfamiliar with HYPERLINK function (relevant information towards the bottom of the page)
https://www.contextures.com/excelhyperlinkfunction.html

[nrj774]

This worked a treat. Exactly what I was wanting to achieve. Many thanks.