Hi

I have tried
http://www.mcgimpsey.com/excel/lookuppics.html
But that only allows for ONE picture to be displayed per page.

I also tried
http://www.contextures.on.ca/excelfiles.html#DataVal
but my Source and Results cells are both sets of merged cells and this
unmerges both the source and results cells.

What I am trying to accomplish is when a person's initials are selected from
a drop down list in cell A1 (which is actually merged A1:B1) i want the
person's signature, saved as an image file, to appear in D1 (which is
actually merged D1:F1). There is a list of 10 rows on each worksheet that
has the ability to associate a signature to a person's initials. So I need
the ability to have various images display multiple times on one worksheet.

ANY help on this would be greatly appreciated. I am at a loss and don't
know how to resolve this.

THanks in advance for time and assistance - Jennifer

Please understand that the images are not actually in the cell but only
overlaid on the sheet.

JB Bates wrote:

Hi

I have tried
http://www.mcgimpsey.com/excel/lookuppics.html
But that only allows for ONE picture to be displayed per page.

I also tried
http://www.contextures.on.ca/excelfiles.html#DataVal
but my Source and Results cells are both sets of merged cells and this
unmerges both the source and results cells.

What I am trying to accomplish is when a person's initials are selected from
a drop down list in cell A1 (which is actually merged A1:B1) i want the
person's signature, saved as an image file, to appear in D1 (which is
actually merged D1:F1). There is a list of 10 rows on each worksheet that
has the ability to associate a signature to a person's initials. So I need
the ability to have various images display multiple times on one worksheet.

ANY help on this would be greatly appreciated. I am at a loss and don't
know how to resolve this.

THanks in advance for time and assistance - Jennifer

Why are you posting this when you have thread already running on same
subject?


Gord Dibben MS Excel MVP


On Wed, 4 Nov 2009 08:51:01 -0800, JB Bates
wrote:

Hi

I have tried
http://www.mcgimpsey.com/excel/lookuppics.html
But that only allows for ONE picture to be displayed per page.

I also tried
http://www.contextures.on.ca/excelfiles.html#DataVal
but my Source and Results cells are both sets of merged cells and this
unmerges both the source and results cells.

What I am trying to accomplish is when a person's initials are selected from
a drop down list in cell A1 (which is actually merged A1:B1) i want the
person's signature, saved as an image file, to appear in D1 (which is
actually merged D1:F1). There is a list of 10 rows on each worksheet that
has the ability to associate a signature to a person's initials. So I need
the ability to have various images display multiple times on one worksheet.

ANY help on this would be greatly appreciated. I am at a loss and don't
know how to resolve this.

THanks in advance for time and assistance - Jennifer