Hi and thanks for having me here!
Unfortunately a series of google and forum searches hasn't been fruitful this time so below is my issue:
I have a workbook that contains 230 sheets which are essentially forms that are pulling data from the first master sheet. Each sheet is named after a specific reference number.
Now, I also have a folder that contains pictures that are named after the relevant reference number as well.
I want to create a macro that will pull the relevant picture to the corresponding sheet. The macro can either read the sheet name or a cell inside each sheet (the ref no can be found inside the sheet too) to determine which photo to pull.
All pictures are/will be resized to the exact dimension I need them to be and the cell will be exactly the same in every sheet.
I have run into multiple problems, so I believe it's better not to bother you with what I have done so far.
Thanks for any help in advance guys!
Bookmarks