Humble Newbie
New Member
- Joined
- Sep 8, 2005
- Messages
- 42
Morning!
I have a sheet that is made up of 2 sections. The top section lists 8 different types of event in chronological order. The bottom half lists the same 8 events but in rank order. A blank row separates each of the events for clarity.
Each of the 8 events has between 5 and 70 rows of data, and 11 columns. Rows are added on an ongoing basis.
What I'd like to avoid if possible, is having to input the information in both sections and being able to view the data in chronological and rank order as quickly as possible.
I am aware of the sort function, but I've found it very tedious and time consuming to define the sort order every time, when the sort order's always the same.
Ideally I'd like to input the information in the chronological order section of the sheet only, and when a particular cell or row for an event is double clicked I then see the event sorted in rank order and then reversed again to chronological order when I double click.
Any suggestions would be most welcome though, and I'll gladly post more info if this is required.
Thank you!
I have a sheet that is made up of 2 sections. The top section lists 8 different types of event in chronological order. The bottom half lists the same 8 events but in rank order. A blank row separates each of the events for clarity.
Each of the 8 events has between 5 and 70 rows of data, and 11 columns. Rows are added on an ongoing basis.
What I'd like to avoid if possible, is having to input the information in both sections and being able to view the data in chronological and rank order as quickly as possible.
I am aware of the sort function, but I've found it very tedious and time consuming to define the sort order every time, when the sort order's always the same.
Ideally I'd like to input the information in the chronological order section of the sheet only, and when a particular cell or row for an event is double clicked I then see the event sorted in rank order and then reversed again to chronological order when I double click.
Any suggestions would be most welcome though, and I'll gladly post more info if this is required.
Thank you!