Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jef Patat
 
Posts: n/a
Default Connecting image to cell


Hi,

I want a certain image to be connected to a certain cell.

The problem I'm facing now is that I insert a certain small image in
column B which is related to the cell in the same row in column A.
When I sort column A alphabetically that works but all the images
remain in at their original position instead of staying connected to
the cell left of them.

On the forum I found this
solution:http://www.mcgimpsey.com/excel/lookuppics.html
But I'm not into scripting and macro's so I don't get it to work.
Another but to me much worse solution, because I can't see the images
immediately.
http://www.contextures.com/xlcomments02.html#Picture

Is there another way?

Kind regards, Jef


--
Jef Patat
------------------------------------------------------------------------
Jef Patat's Profile: http://www.excelforum.com/member.php...o&userid=31106
View this thread: http://www.excelforum.com/showthread...hreadid=507729

  #2   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Connecting image to cell

Not sure if I understand your problem.

A1 contains data, B1 contains an image
A2 contains data, B2 contains an image

You want to sort the whole lot by column A

Select the entire lines 1 and 2 by clicking on the line headers and
then sort. That will keep the data in A1 and B1 together. Alternatively
select A1 to B2 and then sort by column A.

Is that what you meant?

Hans

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link an Image to a cell value hhalle Excel Worksheet Functions 2 January 16th 06 06:16 AM
Is there a way you can get Excel to change an image in a cell barry24uk Excel Discussion (Misc queries) 4 January 4th 06 08:16 AM
Dates of a Day for a month & year cell formulas mikeburg Excel Discussion (Misc queries) 2 December 29th 05 10:14 PM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"