xcellnoob
Board Regular
- Joined
- Apr 6, 2005
- Messages
- 188
I have a worksheet where the information is something like:
A1 B1
Name Playing Date
Mike 10/12/2006
Say 10 or 20 of those with the data sorted descending by date. What I want is if the date changes....I want the whole table to resort based on descending dates. So, say mike is the fourth entry at 10/12/2006 and his date changes to 10/14.2006, then the list would refresh and autosort based on that change.
Is this even possible? Please tell me it is without VBA or macros.
Thanks in advance for any help.
A1 B1
Name Playing Date
Mike 10/12/2006
Say 10 or 20 of those with the data sorted descending by date. What I want is if the date changes....I want the whole table to resort based on descending dates. So, say mike is the fourth entry at 10/12/2006 and his date changes to 10/14.2006, then the list would refresh and autosort based on that change.
Is this even possible? Please tell me it is without VBA or macros.
Thanks in advance for any help.