Hello all,

I have an excel work sheet developed
I would like to add a function that will insert a picture into a cell based on a second cell's value
The second cell value would determined from a list located on a second sheet

I have about 20 pictures that would cross referance 20 values in the list
I would like to store these pictures on the second sheet with the list's

I would like this function to work in 5 different areas on the sheet
all 5 areas would use the same list & same pictures
I would also need to be able to copy the main sheet to create create additional copys of the main sheets lay-out

Can this be done
If so could you please provide me with some information how to do this
If needed I can e-mail my work sheet & gif pictures

Any help would be greatly appreciated

Thanks