Good morning everyone...hopes this finds all well...
Prob a very easy one to solve...I've checked out Dr. Google but haven't quiet found what i'm looking for...
I have a worksheet called Rocks.
I have a folder on C:\ called rock pics
I would like an image to automatically load into cell B2, based on the contents in cell A2...ie...If the word granite is in cell A2, then I would like the granite image (in C:\rock pics) to automatically display in cell B2.
The picture image needs to be 100 x 100.
Any help would be greatly appreciatted.
Cheers,
James
Prob a very easy one to solve...I've checked out Dr. Google but haven't quiet found what i'm looking for...
I have a worksheet called Rocks.
I have a folder on C:\ called rock pics
I would like an image to automatically load into cell B2, based on the contents in cell A2...ie...If the word granite is in cell A2, then I would like the granite image (in C:\rock pics) to automatically display in cell B2.
The picture image needs to be 100 x 100.
Any help would be greatly appreciatted.
Cheers,
James