On Nov 28, 8:59 am, Jerry Manner wrote:
Hi

I am creating an excel template of which the first sheet has lots of
rows. Each row represents a record with data in it ( text, numers and
a small picture)
On the other sheets I refer to cells on the first sheet. I do that
with the formula ( for example) =Sheet1!P5.

This works fine for text and numbers but not for the picture. How can
I refer from another sheet to a cell on the first sheet that contains
a picture?

Any help will be appreciated.

Regards

Hi
Cells in excel don't contain pictures, so you cannot refer to the
picture in a cell. Pictures can have a position relative to a cell,
which you can capture using VBA. You would then have to copy the
picture and paste to a location on your new sheet - all a bit fiddly.
Access cells can contain pictures and other objects. Are you sure you
don't want to be in Access?

regards
Paul