Excel displaying images in one worksheet from another

[matty2470]

I have to make a format for a purchase order which can be used fo
several divisions of a company

At the top I would like the user to be able to select the logo an
address header from their appropriate division.

I guess it would be good to be able to call the image from anothe
worksheet and not from a folder on the server.....I wold like th
format to be independent of any data source....

thanks for helping me with this relatively simple task:-

 

[Dave Peterson]

J.E. McGimpsey has a routine that hides/unhides pictures based on the value of a
cell.
http://www.mcgimpsey.com/excel/lookuppics.html

And if you build a table of addresses, you might be able to use an =vlookup()
formula to return the lines for the address.

Top line of address:
=if(a1="",vlookup(a1,sheet2!a:g,2,false)
Next line:
=if(a1="",vlookup(a1,sheet2!a:g,3,false)
and subsequent:
=if(a1="",vlookup(a1,sheet2!a:g,4,false)
....

 

[matty2470]

This is great info. Spent the night working on the excel sheet image
example from the link you sent.

havent really worked with excel before. Possibly a problem I have bee
having is in spanish version of windows, Office aps expect code to b
written in spanish...which is a bit weird anyway, I made my exampl
file as per the example, but an error shows, and I wonder if you coul
take a look at it. its probably something simple

Could you check it?Please:-