insert picture to a specfic range of cells

Still missing info, but based on what you've shared so far maybe this can work:

Check JE McGimpsey's excellent website:
http://www.mcgimpsey.com/excel/lookuppics.html

If you decide to use the VBA approach (highly recommended), just make sure
that the pictures in Excel are resized to the same dimensions. If you prefer
a non-VBA approach let us know.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CORY" wrote:

> yes, i know how to do that, i was wondering if i could put a formula in that
> first cell that the picture starts from that will tell the photo where to
> end, so i don't have to resize every photo i put in my report. it will
> greatly reduce my time if i can have the photo automacially size to a
> specific range of cells upon inseriton of the photo.
>
> is this possible?
>
> "Ron Coderre" wrote:
>
> > When you insert a picture in Excel, the graphic will start in the active cell
> > on the active sheet and extend down and to the right according to the size of
> > the picture.
> >
> > To change the size you can left-click and hold on any of the "sizing
> > handles" of the picture and and drag to resize it.
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> > XL2002, WinXP-Pro
> >
> >
> > "CORY" wrote:
> >
> > > the only thing that i want to be automatic is the placement of the picture,
> > > like i want it to start at this cell and go to that one. what i am currently
> > > doing is saying "insert" picture, so if that makes the file local to the
> > > workbook then yes they will be local to the work book. i am not sure how to
> > > awnser your last question. i am kind of new to excel.
> > >
> > > "Ron Coderre" wrote:
> > >
> > > > There are ways to work with pictures in Excel, but a little more info would
> > > > be helpful.
> > > >
> > > > Do you want an automatic method for those pictures to be selected or changed?
> > > > Will the pictures be stored in the workbook or are you hoping to retrieve
> > > > them from a network location?
> > > > Do you want the proces controlled by VBA or via formulas?
> > > >
> > > > ***********
> > > > Regards,
> > > > Ron
> > > >
> > > > XL2002, WinXP-Pro
> > > >
> > > >
> > > > "CORY" wrote:
> > > >
> > > > > how can i insert a picture to automatticaly go into a specific range of
> > > > > cells every time. all the pictues will be the same resoulution.

what i learned from that website was this:

"Since pictures in XL can't be placed in a cell, but rather float on top of
the sheet"

that is what i want to do, is place a pictue that spans from (for example)
E40 to Q61. it sounds like i can't do that. i don't really know anything
about VBA (i don't even know what that stands for)

cory

"Ron Coderre" wrote:

> Still missing info, but based on what you've shared so far maybe this can work:
>
> Check JE McGimpsey's excellent website:
> http://www.mcgimpsey.com/excel/lookuppics.html
>
> If you decide to use the VBA approach (highly recommended), just make sure
> that the pictures in Excel are resized to the same dimensions. If you prefer
> a non-VBA approach let us know.
>
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "CORY" wrote:
>
> > yes, i know how to do that, i was wondering if i could put a formula in that
> > first cell that the picture starts from that will tell the photo where to
> > end, so i don't have to resize every photo i put in my report. it will
> > greatly reduce my time if i can have the photo automacially size to a
> > specific range of cells upon inseriton of the photo.
> >
> > is this possible?
> >
> > "Ron Coderre" wrote:
> >
> > > When you insert a picture in Excel, the graphic will start in the active cell
> > > on the active sheet and extend down and to the right according to the size of
> > > the picture.
> > >
> > > To change the size you can left-click and hold on any of the "sizing
> > > handles" of the picture and and drag to resize it.
> > >
> > > Does that help?
> > >
> > > ***********
> > > Regards,
> > > Ron
> > >
> > > XL2002, WinXP-Pro
> > >
> > >
> > > "CORY" wrote:
> > >
> > > > the only thing that i want to be automatic is the placement of the picture,
> > > > like i want it to start at this cell and go to that one. what i am currently
> > > > doing is saying "insert" picture, so if that makes the file local to the
> > > > workbook then yes they will be local to the work book. i am not sure how to
> > > > awnser your last question. i am kind of new to excel.
> > > >
> > > > "Ron Coderre" wrote:
> > > >
> > > > > There are ways to work with pictures in Excel, but a little more info would
> > > > > be helpful.
> > > > >
> > > > > Do you want an automatic method for those pictures to be selected or changed?
> > > > > Will the pictures be stored in the workbook or are you hoping to retrieve
> > > > > them from a network location?
> > > > > Do you want the proces controlled by VBA or via formulas?
> > > > >
> > > > > ***********
> > > > > Regards,
> > > > > Ron
> > > > >
> > > > > XL2002, WinXP-Pro
> > > > >
> > > > >
> > > > > "CORY" wrote:
> > > > >
> > > > > > how can i insert a picture to automatticaly go into a specific range of
> > > > > > cells every time. all the pictues will be the same resoulution.

Ok, Cory

You now understand that you can't put a picture "in" a cell, but you can
place a picture over a cell, or cells, right? So, let's go from there.

For a non-VBA solution, see if this works for you:
Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture, put it in the sheet and
resize it).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant on cells A2:D10:
Select those cells
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.
If you need help: use Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
....or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CORY" wrote:

> what i learned from that website was this:
>
> "Since pictures in XL can't be placed in a cell, but rather float on top of
> the sheet"
>
> that is what i want to do, is place a pictue that spans from (for example)
> E40 to Q61. it sounds like i can't do that. i don't really know anything
> about VBA (i don't even know what that stands for)
>
> cory
>
> "Ron Coderre" wrote:
>
> > Still missing info, but based on what you've shared so far maybe this can work:
> >
> > Check JE McGimpsey's excellent website:
> > http://www.mcgimpsey.com/excel/lookuppics.html
> >
> > If you decide to use the VBA approach (highly recommended), just make sure
> > that the pictures in Excel are resized to the same dimensions. If you prefer
> > a non-VBA approach let us know.
> >
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> > XL2002, WinXP-Pro
> >
> >
> > "CORY" wrote:
> >
> > > yes, i know how to do that, i was wondering if i could put a formula in that
> > > first cell that the picture starts from that will tell the photo where to
> > > end, so i don't have to resize every photo i put in my report. it will
> > > greatly reduce my time if i can have the photo automacially size to a
> > > specific range of cells upon inseriton of the photo.
> > >
> > > is this possible?
> > >
> > > "Ron Coderre" wrote:
> > >
> > > > When you insert a picture in Excel, the graphic will start in the active cell
> > > > on the active sheet and extend down and to the right according to the size of
> > > > the picture.
> > > >
> > > > To change the size you can left-click and hold on any of the "sizing
> > > > handles" of the picture and and drag to resize it.
> > > >
> > > > Does that help?
> > > >
> > > > ***********
> > > > Regards,
> > > > Ron
> > > >
> > > > XL2002, WinXP-Pro
> > > >
> > > >
> > > > "CORY" wrote:
> > > >
> > > > > the only thing that i want to be automatic is the placement of the picture,
> > > > > like i want it to start at this cell and go to that one. what i am currently
> > > > > doing is saying "insert" picture, so if that makes the file local to the
> > > > > workbook then yes they will be local to the work book. i am not sure how to
> > > > > awnser your last question. i am kind of new to excel.
> > > > >
> > > > > "Ron Coderre" wrote:
> > > > >
> > > > > > There are ways to work with pictures in Excel, but a little more info would
> > > > > > be helpful.
> > > > > >
> > > > > > Do you want an automatic method for those pictures to be selected or changed?
> > > > > > Will the pictures be stored in the workbook or are you hoping to retrieve
> > > > > > them from a network location?
> > > > > > Do you want the proces controlled by VBA or via formulas?
> > > > > >
> > > > > > ***********
> > > > > > Regards,
> > > > > > Ron
> > > > > >
> > > > > > XL2002, WinXP-Pro
> > > > > >
> > > > > >
> > > > > > "CORY" wrote:
> > > > > >
> > > > > > > how can i insert a picture to automatticaly go into a specific range of
> > > > > > > cells every time. all the pictues will be the same resoulution.

thank you for the extensive instructions, but i have no need for a pull down
situation that will change the picture. i just want one picture in one spot,
that will automatically size to a range of cells, and that picture has to
come from a jpg file not from another spot within the XL file. i have to try
to keep the file size down, my client is very specific about that.

from everything i have learned today, it seems to me the only way i can do
what i want to do is to manually scale each picture when i insert it.

thank you for trying.

"Ron Coderre" wrote:

> Ok, Cory
>
> You now understand that you can't put a picture "in" a cell, but you can
> place a picture over a cell, or cells, right? So, let's go from there.
>
> For a non-VBA solution, see if this works for you:
> Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.
>
> Select Sheet2 and turn off Grid Lines
> (Tools>Options>View tab:Uncheck Grid Lines)
> 1)For each picture to be displayed:
> 1a. Insert>Picture from file. (select picture, put it in the sheet and
> resize it).
> 1b. Select the range of cells that contains the picture.
> 1c. Name that range of cells, using the prefix "pic" followed by the
> dropdown list text:
> Example for a picture of an Elephant on cells A2:D10:
> Select those cells
> Insert>Name>Define
> Name: picElephant
>
> 2)Build your data validation list on a cell in Sheet1 and pick one of the
> items.
> If you need help: use Debra Dalgleish's site:
> http://www.contextures.com/xlDataVal01.html
>
> 3)Create a dynamic range name that refers to that cell:
> Insert>Name>Define
> Name: ShowMyPic
> RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
> ...or whatever cell you chose.
>
> 4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.
>
> 5)With picture selected, type this in the formula bar, then press [Enter]:
> =ShowMyPic
>
> The picture will be replaced by the picture referred to by the dropdown list.
>
> Each time you select a different item in the list, the associated picture
> will appear in the picture box and resize appropriately.
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "CORY" wrote:
>
> > what i learned from that website was this:
> >
> > "Since pictures in XL can't be placed in a cell, but rather float on top of
> > the sheet"
> >
> > that is what i want to do, is place a pictue that spans from (for example)
> > E40 to Q61. it sounds like i can't do that. i don't really know anything
> > about VBA (i don't even know what that stands for)
> >
> > cory
> >
> > "Ron Coderre" wrote:
> >
> > > Still missing info, but based on what you've shared so far maybe this can work:
> > >
> > > Check JE McGimpsey's excellent website:
> > > http://www.mcgimpsey.com/excel/lookuppics.html
> > >
> > > If you decide to use the VBA approach (highly recommended), just make sure
> > > that the pictures in Excel are resized to the same dimensions. If you prefer
> > > a non-VBA approach let us know.
> > >
> > >
> > > Does that help?
> > >
> > > ***********
> > > Regards,
> > > Ron
> > >
> > > XL2002, WinXP-Pro
> > >
> > >
> > > "CORY" wrote:
> > >
> > > > yes, i know how to do that, i was wondering if i could put a formula in that
> > > > first cell that the picture starts from that will tell the photo where to
> > > > end, so i don't have to resize every photo i put in my report. it will
> > > > greatly reduce my time if i can have the photo automacially size to a
> > > > specific range of cells upon inseriton of the photo.
> > > >
> > > > is this possible?
> > > >
> > > > "Ron Coderre" wrote:
> > > >
> > > > > When you insert a picture in Excel, the graphic will start in the active cell
> > > > > on the active sheet and extend down and to the right according to the size of
> > > > > the picture.
> > > > >
> > > > > To change the size you can left-click and hold on any of the "sizing
> > > > > handles" of the picture and and drag to resize it.
> > > > >
> > > > > Does that help?
> > > > >
> > > > > ***********
> > > > > Regards,
> > > > > Ron
> > > > >
> > > > > XL2002, WinXP-Pro
> > > > >
> > > > >
> > > > > "CORY" wrote:
> > > > >
> > > > > > the only thing that i want to be automatic is the placement of the picture,
> > > > > > like i want it to start at this cell and go to that one. what i am currently
> > > > > > doing is saying "insert" picture, so if that makes the file local to the
> > > > > > workbook then yes they will be local to the work book. i am not sure how to
> > > > > > awnser your last question. i am kind of new to excel.
> > > > > >
> > > > > > "Ron Coderre" wrote:
> > > > > >
> > > > > > > There are ways to work with pictures in Excel, but a little more info would
> > > > > > > be helpful.
> > > > > > >
> > > > > > > Do you want an automatic method for those pictures to be selected or changed?
> > > > > > > Will the pictures be stored in the workbook or are you hoping to retrieve
> > > > > > > them from a network location?
> > > > > > > Do you want the proces controlled by VBA or via formulas?
> > > > > > >
> > > > > > > ***********
> > > > > > > Regards,
> > > > > > > Ron
> > > > > > >
> > > > > > > XL2002, WinXP-Pro
> > > > > > >
> > > > > > >
> > > > > > > "CORY" wrote:
> > > > > > >
> > > > > > > > how can i insert a picture to automatticaly go into a specific range of
> > > > > > > > cells every time. all the pictues will be the same resoulution.