![]() |
how to keep adjacent rows linked when sorting with lists
I want to be able to select "sort ascending" or "sort descending" from the
drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. |
how to keep adjacent rows linked when sorting with lists
Select the whole table (2 columns) before you sort on column B
HTH -- AP "adaire" a écrit dans le message de news: ... I want to be able to select "sort ascending" or "sort descending" from the drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. |
how to keep adjacent rows linked when sorting with lists
On Mon, 03 Jul 2006 09:23:19 +0100, Ardus Petus
wrote: Select the whole table (2 columns) before you sort on column B HTH -- AP "adaire" a écrit dans le message de news: ... I want to be able to select "sort ascending" or "sort descending" from the drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. Quick - tip If you click on a single cell in the table, it will use the *table* containing that cell (Need complete data in table, no blank lines, columns etc) -- Steve (3) |
All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com