Picture Based On A Value In A Cell

Jul 22, 2009

I have found a few solutions here in the message boards but I don't see one that totally matches what I need. Basically I want it to look up the clients logos. We only have a few clients but when sending the report to a client we don't want them to be able to see or find who our other clients are or their logos. So I need it to display a picture based on a value but to also have the pictures on a seperate sheet that I can delete before distributing.


A variation of this would work but this stores all the pics on the report sheet and just hides the non active ones.
[url]

View 9 Replies


ADVERTISEMENT

Picture To Change Based On Cell Value

May 31, 2013

I have posted example work book

Sheet1 has a list that changes based upon input in Sheet2
So, I have reference pictures on Sheet2 that I would like to show on Sheet1 under the corresponding value.

Explanation: on Sheet two a value is assigned (in column B) to each category (Column A) and then it is ranked (Column C)

Sheet 1 lists the categories in rank order.
I want pics to show under each category.

I saw some articles online, but have been unable to make it work.

View 3 Replies View Related

Looking Up And Displaying Picture Based On Cell Value

Nov 13, 2013

I'm looking for a way to insert / display images in a worksheet depending on the value in a cell. The following link is able to do what I need, but it's very limited - i.e. all images must be present in the worksheet first and only the one require is visible:

McGimpsey & Associates : Excel : Display picture based on cell value

I'd prefer to store the images in a normal folder in windows (for a large library of images) and have Excel retrieve the image somehow.

View 1 Replies View Related

Show Picture Based On Cell

Dec 31, 2006

I have folder with 5 photos on c (c:Pictures). Photos are named a, b, c, d, and e. In Excel workbook sheet1 (c:Photos.xls), how to display the photos in cell range (B1:F10) in response to change in cell A1 (i.e., when A1 cell value is “a”, the photo “a” is displayed in the range B1:F10, and so on when the A1 value changes)

View 3 Replies View Related

Loading Picture To Userform Based On Cell

Oct 23, 2013

I'm working on an excel table in which I have the following information:

Product
Date
Defect
Defect Picture

N65-P0421
09/15/2013
Broken tab
D:folderpicture.jpg

N65-P0322
09/16/2013
scratches
D:folderpicture1.jpg

I need a userform in which I choose the field "product" and it loads the picture from the path at "Defect Picture". Is it possible?

View 2 Replies View Related

Insert Picture Based On What Is Typed In Cell?

Mar 27, 2013

Can I have a picture appear next to what is typed in the cell next to it. I have a drop down list of the different pictures I have, I want to select, for example, "star" from the drop down list, can I have a picture of the star appear in cell next to it? I have all the pictures of the words in my drop down list.

View 1 Replies View Related

Macro To Show A Picture Based On A Certain Cell?

Apr 25, 2014

macro which can show a picture of a certain cell and if I change the value of that cell the picture will be changed to the new cell value,

Like

If I put in cell A1 value DOG, so the pic in cell B1 is a dog pic that I defined before, and if I change that value to a cat, the pic should be changed to another pic.

View 1 Replies View Related

Display Picture Based On Text In Cell

Feb 28, 2008

Is It Possible To Embed Pictures So That When I Do Lookup A Code It Then Shows Me The Picture Of What It Is Im Looking For. Ie If I Was To Type In Kettle It Would Show Me A Picture Of A Kettle In The Next Cell?

View 3 Replies View Related

How To Show A Picture In Excel Based On Cell Data

Jan 10, 2005

I have a spreadsheet that queries the web for a weather forecast each day. I'd like to associate pictures on the excel page based on the weather description, but can't figure out a way to select /change the picture automatically.

View 3 Replies View Related

Insert Picture Based On Exact Cell Value From Folder Using VBA

Oct 4, 2013

I am having a product style code in Column A2:A301 from 1 to 300, and I want get picture in next cell ie column B2:B301 based on cell value A2 from a selected folder. Below mention is the snapshot for the same. I am having a product style code in Column A2:A301 from 1 to 300, and I want get picture in next cell ie column B2:B301 based on cell value A2 from a selected folder.

A B
Style_code Picture
1
2
3
4

View 9 Replies View Related

Display A Picture In A Cell When The Picture Name Is Selected

Jun 18, 2014

I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula

My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.

View 6 Replies View Related

Excel 2003 :: Put Picture Into A Cell And Get Picture Name From Another Cell

Mar 23, 2014

I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.

The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.

My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).

I've tried many macros but none work.

View 14 Replies View Related

Write The Picture Name In Cell The Picture Will Appear

Jan 22, 2009

i have saved some pictures in my excel sheet.
in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.

View 10 Replies View Related

Populating Picture Based On Number?

Jul 2, 2014

I have a large excel workbook that is full of data about certain parts. I am able to enter a number and populate the sub item using VLookup but I would like to populate a picture based on the sub item. The pictures are located in there own folder inside the folder where this excel file is located.

View 3 Replies View Related

Displaying A Picture Based On A Formula

Feb 1, 2014

I am working on a spreadsheet that calculates sales results weekly / monthly / quarterly / and year to date. I need to be able to get a picture to automatically populate in a specific fields based on the sales results for that week / month / quarter / year. There are 3 pictures indicating: sales below budget (sad face), above budget but below goal (black dot), and above goal (gold star). I have tried using non-macro means, but I can't seem to get anything to work for use with multiple cells and I do not wish to use conventional conditional formatting. I do not know nearly enough about macros or VBA to even attempt this type of thing.

View 2 Replies View Related

Excel 2010 :: Paste Picture Into Small Picture / Diagram Box?

Mar 19, 2012

In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?

View 1 Replies View Related

Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Nov 18, 2007

I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice

View 6 Replies View Related

Inserted A Listbox And Based On The Value Selected A Picture Should Be Poped

Jul 12, 2009

I have inserted a listbox and based on the value selected a picture should be poped. I have searched the forum and got the code below. But it is throwing an error message "object required"

Private Sub ListBox1_Change()
If ListBox1.Value = "x" Then
Pictures("Picture 1").Visible = True
Else
Pictures("Picture 1").Visible = False
End If
End Sub

Then i modified it to

Sub ListBox1_Change()

If listbox1.Value = "1" Then
activesheets.Shapes("Picture 1").Visible = True
Else
activesheets.Shapes("Picture 1").Visible = False
End If
End Sub

View 9 Replies View Related

Use Picture Name From A Cell

Nov 17, 2006

I have recorded a macro for inserting, sizing and positioning a product photo into a report. The photo file is in a directory containing many files. Filenames are alpha numeric codes with a .jpg extensions. I wish to be able to enter a different code into a spreadsheet cell which will be named and let the macro insert the proper photo from the files in the subdirectory.

Here is the code which was recorded and which brings up the photo for file "HGGA134.jpg ".

Range("B10").Select
ActiveSheet.Pictures.Insert( _
"C:Documents and SettingsRichard WrightDesktopNUEVOProduct PhotosHGGA134.jpg" _
).Select
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 195#
Selection.ShapeRange.Width = 180#
Selection.ShapeRange.Rotation = 0#
End Sub

I need a way to change the "HGGA134" part of the code by having it reference a named cell in the report.

View 5 Replies View Related

Insert Picture From File Increases File Size More Than The Picture You Inserting

Mar 17, 2009

I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB

why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?

View 9 Replies View Related

Add Picture To Cell Comment

May 15, 2008

i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Ideally like what happens with the comments where you hover over the cell and the comment would pop up. or failing that may be a cell linking to the image.

View 8 Replies View Related

Duplicate Picture Into Another Cell?

Dec 19, 2013

I have a workbook that has 32 pictures identically formatted. I used info from McGimpsey website for displaying a picture base on a cell value which works fine but I need that same picture to display in a few other cells. Is this possible?

View 6 Replies View Related

Looking For A Cell To Make A Picture Pop-up?

Jan 17, 2014

Is it possible to have an "If this cell equals this amount, then make a picture appear" scenario?

Say there's a blank sheet, but if cell A1 is 1, then there will be a picture (or shape) in the center of the sheet.

View 2 Replies View Related

Inserting Picture If Cell Value Less Than 10

Mar 5, 2014

I have two images that have a name on each sheet for reference. One is a thumbs up image, one is a thumbs down. They are both named tu_image and td_image respectively. I want to show the thumbs up image if a particular cell has a value of 10 and show the thumbs down image if that cell's value is < 10.

This check and display needs to be done about 20 times on different sheets and with different values. (i.e. Thumbs down should only show when the value is < 20, instead of 10.) Ideally this should take place when the workbook updates with new data. Is this possible?

View 1 Replies View Related

Shrink Picture For A Cell (use VBA)

Apr 17, 2009

I want to insert a picture on a cell of Excel. But this cell is too small. How do I shrink picture for a cell (use VBA)

View 2 Replies View Related

Linking Picture To Cell?

May 25, 2013

in sheet 1 i have the following format item # and picture in the next column (suppose that "picture here" is the picture of the item

#)
sheet 1
item#

[Code]....

in sheet 2 i want that when i write the item # then the picture in the next column will be shown from sheet 1.

View 4 Replies View Related

Put A Picture As Background For A Cell?

Jul 19, 2014

Can you Put a picture as a background for a cell?

View 1 Replies View Related

Way Of Associating A Cell With A Picture

May 24, 2007

Does anyone know of a way of associating a cell with a picture?

for example, if you click on a button, the picture appears in cell A1?

View 13 Replies View Related

Unhide Picture If Cell Contains Value

Mar 21, 2009

I have attached a simplified version of the xls I am using. On the attached xls there are two tabs. The first tab (BUYS) has linked pictures of cells on the second tab (Warehousing).

I would like some code which would display the pictures only when the corresponding cells in Column F have a number in it. (This number could be anything)

e.g. If cell F4 has a number in it show Picture 1
If cells F4 and F5 have a number in them show Picture 1 and 2

My full xls (not attached) has another tab called SELLS. These two tabs (BUYS and SELLS) have 15 pictures each (1 for each row 4:18).

Ideally an exception would be written into the code so that if the xls was named "yymmdd Asian Executions" or "yymmdd Europe Executions" none of the pictures would show up.

I hope I have been clear but it's very difficult to be objective so please let me know if you need any more information.

View 8 Replies View Related

Inserting A Picture Into A Cell

Jun 6, 2006

I am looking for a way to insert a picture into a cell BUT the picture should not float. It should change its size whenever the cells size changes - as if it was inserted into a rectangle drawn from the "PAINT" Bar. An example (but it floats) can be seen in the attached picture/

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved