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.
I am making a spreadsheet which would have the record of the audit that i am doing on my patients. Along with other details i want to give link of the routine followups of their disease picture in their specific spreadsheet cell. I have searched the internet about it where i have come to know about hyperlinking. However, my concern about hyperlinking is that i want the spreadsheet with pictures to be portable to other PCs which wouldn't be possible with hyperlinking. Also including the pictures in the spreadsheet would be very troublesome as the size would enormously increase once the data continues to grow.I want to include photos in column L, R, V, Z & AD.
View 3 Replies View RelatedI 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.
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.
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.
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 RelatedI 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 RelatedI 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.
When I am in my workbook and I click on a cell in a worksheet I would like to be able to have the row highlight when I click a cell, instead of trying to manually find it which at times I get lost with all the data on these sheets. Now my workbook is completed and all my formulas are done. Just trying to fine tune my databases with being able to do the "click this cell and the row highlights where I need to be" If this is possible I would like to do this for all 3 databases.
View 14 Replies View Relatedthis have bothered me for a long time. I'm not a very good excel user, so it's probably a piece of cake for some here ^^; This table;
Student Test1 Test2 Test3
a 13
b 16
c 19
d 9
e 15
etc...
Later in the document I want to show WHO scored highest on each test in another table;
Best Student Points
Test1 19
Test2
Test3
The points are easy to figure out, even for me, just use the "MAX" function. But how do I make excel tell me "c" under "best student"? Ofcourse I want it to be a function so that it'll change when I set 20 on student a.
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....?
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 RelatedI 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 RelatedIs 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.
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?
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 RelatedCan you Put a picture as a background for a cell?
View 1 Replies View RelatedDoes 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?
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]
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.
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 Relatedi need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Idealy like what happens with the comments where you hover over the cell and the comment would pop up. or failing that mabe a cell linking to the image.
View 6 Replies View RelatedI am trying to have a cell in a diffrent work sheet display information from another sheet.
I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.
I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.
I have a workbook with 6 tabs/worksheets. Each of the first four is a different product or quarter. Tab 5 is a consolidated data report that links data from individual tabs 1-4 in rows and columns for comparison purposes. Consider Tabs/Worksheets 1-4 to be quarters (ie. 1Q, 2Q, 3Q, 4Q). What I want is for the Column Headers in Tab 5 (the consolidated data report) to be pulled from the NAME of the Tab/Worksheet it is pulling the data from. Not an individual cell, but the name of the worksheet itself so that others can change their worksheet labels and those changes are reflected in the consolidated report.
View 1 Replies View RelatedI have a cell, C2, that will have a tab name pasted into it each time a new page is created. This name will be equivalent to a filter in PivotTable1 on that page.
Is there a way that I can have it that when the name is pasted, the filter "Time" can be linked to that cell and update in the pivot table?
I go to last used row for column C and then go to next row column A and insert a check box and link that to same row in z column. The code which I am trying is not working.
lastcell is last used cell in column c. Say C8 (c8,c9 are merged). A to column H are merged.
[Code] .....
I dont know why i am unable to go to A10 with the above code.
and for check box i am try with macro recorder.
[Code] .....
Checkboxes are inserted with every new row. I am able to add row and merge the rows and I am struck at adding checkboxes.
Could you program an example where the object size (arrow) is linked to a cell value?
I have two cells on Sheet 1 - Cell A1 and Cell A2.
Cell A1 is the first cell that will receive either a number, or nothing. When it receives a number, the number will always contain five digits. (For example: '23456'.)
The contents of Cell A2 depend on the contents of Cell A1 - If Cell A1 contains a five digit number, then Cell A2 will display that same five-digit number with '-1' following it. (In our case: '23456-1'.) If Cell A1 contains no number, then Cell A2 will just be another ordinary cell allowing the user to enter whatever he/she desires.
The extension in Cell A2 should remain editable at all times - if the user wishes to change the '-1' to a '-2', for example, he/she should be able to do so without any error messages appearing. However, the user must not be able to change any of the first five digits in Cell A2 as long as Cell A1 contains data. A message should appear stating that changes to the first five digits should be performed in Cell A1 - which would then change Cell A2 accordingly.
Also, if the contents of Cell A1 are erased for any reason, Cell A2 should keep the five digit number, but lose whatever '-x' extension it contained.
Can this be done using Data Validation?
=SUMPRODUCT(--(Sheet2!$M$2:$M$11=Sheet1!$B$3),--(Sheet2!$N$2:$N$11=Sheet1!$B$4),Sheet2!$A$2:$A$11)
inthe above quoted formula last part "Sheet2!$A$2:$A$11" is the data for Jan in sheet2, if I need Feb results I need to change it to "Sheet2!$B$2:$B$11"
Is there a way to make it dynamic by linking this to a cell on sheet1? Example if sheet1 A1 cell contains name of month, by changing that the results should also change?
One folder on the drive contains excel files, which are created daily from a template. I use these files, the 20 most recent days' worth, to create an analysis file. This new file is organized in rows, starting with the date. The files I am using are all saved in the form "Stats yyyy mm-dd.xls" The first line of each row of the analysis spreadsheet starts with the date, in the format "yyyy mm-dd". Is it possible to create a macro, or in another way, for the analysis spreadsheet to automate the reading-in of data from these different files?
View 2 Replies View Related