If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
resetting last cell | jagdish.eashwar | General Discussion | 11 | March 31st, 2006 02:06 AM |
Inserting rows, updating linked worksheet | Patti | Worksheet Functions | 2 | March 20th, 2006 09:25 PM |
Sorting lists | famdamly | General Discussion | 2 | February 26th, 2006 09:58 PM |
Sorting with Multiple Rows per Entry | Andrew Roberts | Worksheet Functions | 12 | February 25th, 2006 05:14 AM |