close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()