DESCENDING ORDER -in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I keep attendance for about 30 people . I have a spreadsheet for each
person. When someone is out I add the date at the bottom of the list.
Since this has to be maintained in descending order I sort the columns. It
takes me more time to sort the columns than entering the dates. Is there a
way to make this process faster. thank you
 
if it is not a problem, maybe u can just insert a full row on the top of the
list to place the latest date.
 
In xl2003, you can apply data|filter|autofilter to the range and use the
dropdown arrow to sort your data.

Debra Dalgleish has a technique at her site that adds invisible rectangles in
the headers and then sorts the data by that field when you click on one of those
rectangles.

http://contextures.com/xlSort02.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting the data in descending order 3
Excel List Sorting Problem (Descending) 2
Acending descending filter screwed my spreadsheet... 2
How do I create a purchase order log in Excel? 1
Sort problem 2
How do I sort subtotals for groups in Excel ? 5
Sorting/Filtering 5
calculate totals 3

Back
Top