To Do List - Creating one in Excel

damian_r

Active Member
Joined
May 4, 2004
Messages
389
Hi folks,

Has anyone ever tried creating a 'To Do Remider List' using Excel, using such fields as Projects, Date added, date due, level of importance etc etc etc

Does anyone have any ideas as to what they might want on such a list as once i've created mine I'll freely give it out ot others (even though it'll be a VERy basic spreadsheet)


Damian
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Yes, Damien, this is a very common use of Excel. In my version I use logical indicators to yellow-highlight the next recurring event. Because of the extended criteria, Outlook was not a good answer so I used Excel to create this.
 

damian_r

Active Member
Joined
May 4, 2004
Messages
389
Hmm, sounds interesting!

. . . . but i must ask, what do you mean by logical indicators?


Any chance of a screen shot of what yours looks like?


Damian
 

damian_r

Active Member
Joined
May 4, 2004
Messages
389
Taking my thoughts further, is the following possible and how would you go about doing it.

1) Have a button, that when clicked on would automatically bring up a pop up box which wold have cells that you filled in which 'copied' the various contents to the corresponding cells in the to do list.

2) have the list continually autofilter based on teh contents of a certain column, such as level of importance ie, VH, H, M, L, VL


Damian
 

damian_r

Active Member
Joined
May 4, 2004
Messages
389
. . . . . Anyone willing to give examples of their spreadsheets and the trickery thay have made it do?


D
 

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Screen shots require an external website.

By logical indicators I mean that each task's highlight on/off is controlled by as little as one or as many as 7 different logic indicators. For example, one particular task is monthly on the second to the last wednesday of the month unless the upcoming 25th of the month falls on the weekend. If so, then the task is done two days earlier.

So in one column I have logic that turns TRUE/FALSE depending on if the 25 occurs on the weekend, in another column I have logic that checks the date, and finally in another column I have other logic. All of these resolve to TRUE/FALSE. Last, in the "master" logic column, If all the other pieces are TRUE, the master turns to TRUE. Conditional formatting reads the Master value TRUE (for the record/row) and turns on the highlighting.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,386
Messages
5,571,829
Members
412,421
Latest member
grace_abar
Top