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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,002
Messages
5,834,821
Members
430,324
Latest member
bosphoruskid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top