Add Multiple Hyperlinks to Multiple Cells in Worksheet
Hie, Facing Problems in Adding Multiple Hyperlinks to Multiple Cells in Sheet in One Go. Example Given Column B Contains the Hyperlinks, Having the Name of the...
Hie,
facing problems in adding multiple hyperlinks to multiple cells in sheet in one go.
column B contains the hyperlinks, having the name of the file common to column A
wants that if its dragged down it should change the hyperlink as per the source data.
1 Answer
Here's the formula to generate the first link, in cell B1:
=HYPERLINK("C:\Users\sameer\Desktop\hyper\" & A1 & ".jpg")
You can drag down column B to generate the other links.
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
