Auto update hyperlink on the other sheet
Closed
eunice3301
eunice3301
- Posts
- 13
- Registration date
- Thursday July 27, 2017
- Status
- Member
- Last seen
- August 29, 2017
eunice3301
- Posts
- 13
- Registration date
- Thursday July 27, 2017
- Status
- Member
- Last seen
- August 29, 2017
Related:
- Auto update hyperlink on the other sheet
- Auto update data in another excel sheet ✓ - Forum - Excel
- Auto notify of email when excel sheet updated ✓ - Forum - Excel
- Auto update excel sheet from another sheet - Guide
- Auto notify or mail when excel sheet updated. ✓ - Forum - Excel
- Excel duplicate sheet auto update ✓ - Forum - Excel
2 replies
BrianGreen
Aug 7, 2017 at 06:44 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
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 :^)
Click on cell A1 in Sheet 2
Type "=Sheet1!A1" (no quotes)
Click on any other cell.
All done :^)
eunice3301
Aug 8, 2017 at 12:59 AM
- 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=)
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=)
Aug 8, 2017 at 12:54 AM
Thank you so much for the reply.
I tried it but it doesn't work.
Is there any other formula?
Thank you