ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pictures to work with "data" "sort" option (https://www.excelbanter.com/excel-discussion-misc-queries/83839-pictures-work-data-sort-option.html)

arad

pictures to work with "data" "sort" option
 
I have a data table with details regarding an object in every row.
I would like to add picture to every row that will stay attached to the
object while i make "data" "sort".

but the pictures don't want to move with the rest of the row.

Is there a solution ?

thanks
Arad

mrice

pictures to work with "data" "sort" option
 

This can be done by the following...

Add a comment to the cell which is the same as the name of the
picture.

Create a macro which reads the comments and repositions the picture to
a fixed offset from the top and left values of the cell.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533903



All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com