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?

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


On Thu, 16 Aug 2007 17:44:13 -0700, Confused at Work
wrote:

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?