Copying Image from one worksheet to another

[jemmaescott]

Hi All;

I am new to this forum and I know there have been some posts before about this but...

I can write a few formulas in excel, but never use VB or macros.

I have two worksheets, a summary and a detailed.

I want to copy the cell information from the detailed sheet to the shortened summary.

So far to do this I am just typing the = key so it picks up what is in the cell on the other sheet.

The problem I have is that in some of cells on the detailed sheet there are pictures rather than text, so when I type the = it returns a value of 0.

So how do I very easily, copy the images using the = (if possible) from one cell to another.

as you can see i am quite a basic user of excel so any help is appreciated.

Many Thanks

 

[GlennUK]

Pictures can't be stored in cells ( well, they can, in the comments actually, but that's another story ) ...do you mean that there are pictures embedded over a cell, and that's what you want to copy across using a formula?

 

[jemmaescott]

Hi Glyn;

Yes the image is embedded in the cell.

I think I may be able to solve my problem perhaps by recording a macro of me just copying and pasting manually all of the images?

Would love to know if there is a forumula though.

Many Thanks

Jemma

 

[jemmaescott]

oops I meant Glenn! we have a Glyn and Glen at work here and I always mix them up.

 

[GlennUK]

oops I meant Glenn! we have a Glyn and Glen at work here and I always mix them up.

Ha ha, don't worry about that ... I've had people say worse ( on here ... and recently too unfortunately ).

A macro sounds like a good idea. See how that goes for you.

If you are wanting to copy images depending on certain values, then formulas might be more useful ... but that are bit tricky. You'd use the camera tool to generate a picture and then use defined names to specify the content ... it's covered briefly here.

http://en.allexperts.com/q/Excel-1059/conditional-picture-showing.htm

If you want more info then post back, and I'll see what I can do.