Hi everyone - my first post! I hope someone here might be able to assist me.
I would like to hyperlink each row of my Excel spreadsheet to the corresponding photo of the person in that row. All the photos in a batch are sequentially numbered in the same order as the rows.
Eg the first row of the spreadsheet for batch 2 might be:
Doe John, London, Male
and the first photo in batch 2 (a photo of John Doe) would be called, say, C:/images/batch2/0243.jpg
The next row might be:
Doe Jane, New York, Female
and the second photo in batch 2 (a photo of Jane Doe) would be C:/images/batch2/0244.jpg
Clicking on any cell in a person's row would bring up their photo. Ultimately I want to sort the rows alphabetically by surname, so each hyperlink would need to move with its person to keep their photo linked to their record.
Is there a quick way to do this, rather than manually using Insert Hyperlink for each row? I've seen some similar threads here, but couldn't find anything precisely on this one. I imagine it must be a fairly common requirement.
Any help appreciated.
I would like to hyperlink each row of my Excel spreadsheet to the corresponding photo of the person in that row. All the photos in a batch are sequentially numbered in the same order as the rows.
Eg the first row of the spreadsheet for batch 2 might be:
Doe John, London, Male
and the first photo in batch 2 (a photo of John Doe) would be called, say, C:/images/batch2/0243.jpg
The next row might be:
Doe Jane, New York, Female
and the second photo in batch 2 (a photo of Jane Doe) would be C:/images/batch2/0244.jpg
Clicking on any cell in a person's row would bring up their photo. Ultimately I want to sort the rows alphabetically by surname, so each hyperlink would need to move with its person to keep their photo linked to their record.
Is there a quick way to do this, rather than manually using Insert Hyperlink for each row? I've seen some similar threads here, but couldn't find anything precisely on this one. I imagine it must be a fairly common requirement.
Any help appreciated.