Changing a Photo based on cell Value in Excel

Occasional Visitor

Running Excel "Office365 for Business"  I want to type in a photo file name and have the image shown change to the filename from a folder the excel file sits in:

GSAInsp_0-1627767326348.png

 

Columns A, B, E, F, G, & H always stay the same.

Column C will contain the image name

Column D is the Image - Note: the image must be named "Picture" & the number in Column A

There are 188 photos that would need to be modified based on the value of Column C.

 

This is a much larger project then just this worksheet and will have to be able to change based on where the excel file resides.

i.e.

\\server\folder1\folder2\workingfolderALPHA\File.xls 

\\server\folder1\folder2\workingfolderBETA\File.xls 

 

I have already defined the worksheet as a TABLE with the columns NAMED and correspond with other worksheets in the file.

1 Reply

@GSAInsp 

Here are some suggested solutions, see the file, even if I did not understand what exactly your plan is. The translation doesn't help either.

 

But I recommend you insert a file (without sensitive data) and explain your project in detail in this file. Knowing which Excel version and operating system you have at the same time would be beneficial for everyone involved.

 

Recommend you to read this link:

Welcome to your Excel discussion space!

 

Hope this information could help you.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.