Hi guys,
I am building a number of reports for a retail firm. The numbers are straight forward but the creatives want to see images of each item in the report. Each item (T-shirt, jeans, jacket etc) has an item number. For each item number I have a picture of the item saved in a folder.
C:\Users\RichardNero\Documents\Retail Images\
The item numbers will look like this
<tbody>
</tbody>
All the files will be saved as jpegs (.jpg).
What I want to do is loop through my list of item numbers in column A and source the corresponding picture from the folder into the adjacent cell in column B. The picture will need to size to the exact parameters of the cell.
Would be nice to have some sort of error catch that says if it cant find the image from the item number it writes in the cell "Image not found".
I hope that makes sense.
Thanking this awesome community in advance!
Richard
PS: I have spent a while googling this but cant seem to find anything on the subject.
I am building a number of reports for a retail firm. The numbers are straight forward but the creatives want to see images of each item in the report. Each item (T-shirt, jeans, jacket etc) has an item number. For each item number I have a picture of the item saved in a folder.
C:\Users\RichardNero\Documents\Retail Images\
The item numbers will look like this
000151 |
1004851 |
1004852 |
1004853 |
BKM730MW |
BKM731MW |
BKM733MW |
<tbody>
</tbody>
All the files will be saved as jpegs (.jpg).
What I want to do is loop through my list of item numbers in column A and source the corresponding picture from the folder into the adjacent cell in column B. The picture will need to size to the exact parameters of the cell.
Would be nice to have some sort of error catch that says if it cant find the image from the item number it writes in the cell "Image not found".
I hope that makes sense.
Thanking this awesome community in advance!
Richard
PS: I have spent a while googling this but cant seem to find anything on the subject.