Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for today and another for high-priority tasks coming up within a week.

I have not programmed in Excel before. I know Python and JavaScript, but want an Excel solution that runs inside Excel (maybe using VBA, the Excel programming language).

Is this sort of thing possible in Excel?

share|improve this question
1  
Your question asks if it is possible. Yes. Defining where you prioritize tasks is necessary. It sounds as if you define them by more than just date. –  datatoo Aug 5 '12 at 18:48
add comment

1 Answer 1

Assuming Excel 2007 or later:

  1. Define what is "Priority" (Column B in example).
  2. Flag those that are due within 1 week =IF(AND(B2="Priority",C2<NOW()+7),1,"") in D2 in example, and copy down.
  3. Create a pivot table from ColumnsA:D (Report Filter = Priority, Row Labels = Date and Task), filter on Multiple Items: Priority and (blank).
  4. Take copy of pivot table, change Report Filter to "Priority Imminent" and filter on "1".
  5. Refresh as and when desired.

SU457719 example

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.