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 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.