![]() |
Sorting Objects with the rest of the cells
Hi,
I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
Sorting Objects with the rest of the cells
The object must reside entirely within the boundries of a cell to sort. Also
it must be formatted to move with the cells. What type of object are you using? -- HTH... Jim Thomlinson "Garrett" wrote: Hi, I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
Sorting Objects with the rest of the cells
THANK YOU!! That worked perfectly. I was linking word docs to accounts. I
used an icon to represent the file but I did not have the cell big enough. Once I adjusted the size of the cell the data sort perfectly. Thanks again!! "Jim Thomlinson" wrote: The object must reside entirely within the boundries of a cell to sort. Also it must be formatted to move with the cells. What type of object are you using? -- HTH... Jim Thomlinson "Garrett" wrote: Hi, I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com