I have an excel sheet where column "B" has a list of style numbers . I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column "A" beside their respective codes. If possible, I would also like to reformat the pictures so they fit in the cell. Size= (3.00 x 3.85)
I want to be able to press for example :CTRL Q and all the the pictures will pull from the folder on my PC and populate in column A next to their respective style # in column B.
Need a Macro that can run this.
I don't really know where to start and any help would be greatly appreciated!
If anyone could write this code that would be great.
Thanks
I want to be able to press for example :CTRL Q and all the the pictures will pull from the folder on my PC and populate in column A next to their respective style # in column B.
Need a Macro that can run this.
I don't really know where to start and any help would be greatly appreciated!
If anyone could write this code that would be great.
Thanks
