I'm trying to produce an excel sheet where I display several images present on a specific folder in my computer.
I'll have a reference cell for each picture where I store the path to the file.
I want to use those references to load image and place it in a cell a number of rows above the cell with the referenced path for the file.
There are several available solutions for this but the tricky part is that I want to be able to copy that column, paste it elsewhere in the sheet, change the path to the file in the new generated column and obtain the corresponding image in the correct place.
Is there a way of doing this? Can someone help?
Inporting images from folder to excel using a cell as reference