Excel displaying images in one worksheet from another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matty2470 - 15 Mar 2006 23:48 GMT

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:-

Reply to this Message

Dave Peterson - 16 Mar 2006 01:06 GMT

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)
...

> I have to make a format for a purchase order which can be used for
> several divisions of a company
[quoted text clipped - 13 lines]
> matty2470's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32494
> View this thread: http://www.excelforum.com/showthread.php?threadid=522882

Signature

Dave Peterson

Reply to this Message

matty2470 - 16 Mar 2006 17:55 GMT

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:confused:

Could you check it?Please:-

Reply to this Message