PICTURE HELP PLEASE!!

[Guest]

I HAVE 8 LOGOS ON WORKSHEET CALLED "LOGOS". I ALSO HAVE CUSTOMER NAMES ON A
SEPERATE WORKSHEET CALLED CUSTOMERS. ON MY MAIN INVOICE WORKSHEET CALLED
MAIN, CELL D8 IS A NUMBER. IF I ENTER 1 THROUGH 8 IT BRINGS UP AUTOMATICALLY
FROM CUSTOMERS TAB THEIR NAME. FROM THAT AT THE BOTTOM I WANT IT TO ALSO
BRING UP THEIR LOGO FROM LOGOS WORKSHEET AND PASTE IT ON THE BOTTOM OF THE
PAGE. DOES ANYONE KNOW HOW TO DO THIS?

 

[Gord Dibben]

Please drop the ALL CAPS.

Hard on the ears and difficult to read.

To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed.

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP