Images within tables

[BluePenguin0]

Hi,
I have a 'lookup' table with the following fields:
CODE, DESCRIPTION, PRICE, IMAGE
As the names suggest 'image' is a picture of the item.

On a separate sheet I have a 'specification' table with the following fields:
ROOM, CODE, DESCRIPTION, PRICE, IMAGE, QUANTITY, TOTAL

On the 'specification' table, the user selects a ROOM
and then a CODE (from a dropdown list populated from entries in the 'lookup' table)
the DESCRIPTION, PRICE and IMAGE fields are automatically updated to include the corresponding data from the 'lookup' table
The user enters a QUANTITY and then the TOTAL is calculated.

OK, here are the problems...
1. How do I get excel to populate the IMAGE field in the 'specification' table with the correct picture from the 'lookup' table?
2. I want to be able to create a pivot table from the 'specification' table, will I be able to show the IMAGE field in the pivot table? How?

Many Thanx,
Andy

[ashishmehra2010]

Hi,

Welcome to the forum!

Consider posting a sample file to get faster results.

Regards,
AM

[Kyle123]

Quite simply, you can't. Probably not the answer you were looking for though!

[BluePenguin0]

Ta...thought you'd say that!
Will have to go down another route
Andy