Previous Topic Next Topic

Auto update hyperlink on the other sheet

Closed
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
 - Updated on Aug 7, 2017 at 04:52 PM
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
 - Aug 8, 2017 at 12:59 AM
Hello guys =)

Please help...

I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the ID has expired and i want to update the hyperlink of the ID, is it possible that if i change the hyperlink in the 1st sheet the 2nd sheet also will automatically copy the updated hyperlink from 1st sheet?

Please help..

Thank you

2 replies

Answer 1 / 2
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
 145
Aug 7, 2017 at 06:44 PM
Assuming the cell you want to copy is in Sheet 1 cell A1 and you want to replicate this on Sheet 2 cell A1.

Click on cell A1 in Sheet 2
Type "=Sheet1!A1" (no quotes)
Click on any other cell.

All done :^)
0
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
Aug 8, 2017 at 12:54 AM
Hello Brian,

Thank you so much for the reply.

I tried it but it doesn't work.

Is there any other formula?

Thank you
0
Answer 2 / 2
eunice3301
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
Aug 8, 2017 at 12:59 AM
Brian,

Sorry i forgot to mention that the hyperlink is to open the ID in jpg file. Suppose the ID has expired, i will update the file and change the hyperlink for the new ID jpg file.is it possible that if i will update the 1st sheet the 2nd sheet will also update automatically?

Please help..

Thank you=)
0