ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to keep adjacent rows linked when sorting with lists (https://www.excelbanter.com/new-users-excel/97290-how-keep-adjacent-rows-linked-when-sorting-lists.html)

adaire

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.



Ardus Petus

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.





SteveW

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