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: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.
www.contextures.com/xlcomments02.html#Picture
Is there another way?
Kind regards, Jef--
Jef Patat
------------------------------------------------------------------------
Jef Patat's Profile: www.excelforum.com/member.php...oamp;userid=31106
View this thread: www.excelforum.com/showthread...hreadid=507729Not 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
- Jul 20 Thu 2006 20:08
Connecting image to cell
close
全站熱搜
留言列表
發表留言