Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a picture in a cell
Hi all, This seems like a simple problem, but here I am anyway. I have a series of simple pictures in a spreadsheet. Depending on what the user inputs into A1, I want A2 to show the corresponding picture. For example if the type "cat" in A1, the A2 would show a picture of a cat. The pictues are already in the spreadsheet, it's just a matter of finding a function that will copy the cell that it's in & paste it into A2. If I manually copy & paste the cell it works, but I'm looking for a formula that can do that. I've also tried naming the picture & using an if function. IE: =if (A1="cat",cat,""). But what that did was paste the words "group312" in the cell instead of the picture. I prefer to keep this away from turning into a VB project. Can anyone help? Thanks, Bill -- Soundman ------------------------------------------------------------------------ Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428 View this thread: http://www.excelforum.com/showthread...hreadid=556779 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
please help! Linking a picture to a cell and recalculating automatically | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |