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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,685
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,685
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,517
Messages
5,832,223
Members
430,116
Latest member
d1pakjha

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