I am trying to insert pictures of candidates by checking their id number. If the id number (in sheet2 column B) matches with the filename in the directory of photos, then that candidates picture from the file location is inserted in a specific cell. The candidate list can vary in length.
I can insert the picture of ONE candidate by pointing to the exact location - that's not a problem.
However I am trying to loop through the id numbers on sheet2 and have become unstuck. I have tried various things and got some help (thanks TG) but still getting errors. Due to trying various things my code does look a bit funky right now - so apologies(!)
Also when the pictures are placed in the cell (starting at cell A12 Sheet1), then I need to fix the picture in the centre of the cell at fixed dimensions so that if there are lots of pictures, there's uniformity)
Can anybody help? File attached and thanks in advance.