dafydd_jwc
New Member
- Joined
- Dec 1, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet of all the stock our company has, and would like to add images to it (we produce board games & jigsaws!). We have product codes - a letter and 3 or 4 digits (e.g. A123)
All the images will be named as their product code - e.g. "A123.jpg"
I have a column which has all the codes, I have a column which has concatenated the product code and '.jpg', but I don't know how to write the code to insert the image associated with that product in the next cell over. The images would need to go into column D, starting at cell D2.
Hope someone is able to help!
All the images will be named as their product code - e.g. "A123.jpg"
I have a column which has all the codes, I have a column which has concatenated the product code and '.jpg', but I don't know how to write the code to insert the image associated with that product in the next cell over. The images would need to go into column D, starting at cell D2.
Hope someone is able to help!