Copying Image from one worksheet to another

jemmaescott

New Member
Joined
Mar 25, 2011
Messages
3
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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,523
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

New Member
Joined
Mar 25, 2011
Messages
3
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
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,523
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,577
Messages
5,596,996
Members
414,116
Latest member
sfullnet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top