simple todo

[thirty]

I need help with creating a simple task list. Col A would be a priority number from 1 to 5, drop down list. Col B would be the task itself. Col C is the tricky part. I would like to assign Categories to each task from a drop down list (or some other way), BUT I would like to sometimes assign more than one category to a task. For example: I would have a task, say BATHE CAT, and I would like to assign it to a category named Cats AND a category of URGENT. I would like this task to show up in both categories sorted lists. When I delete this task it disappears from both category lists. I would like to have maybe 20 categories, but with the ability to add and delete categories. Something like outlook's task list. AND when a task with a category is created then a separate worksheet with only that category task is created, sorted by the priority number in Col A.

Maybe Col D would be for Creation Date, with "todays date" automatically entered when task created so that I can sort for the most recent tasks. It's nice to click on a tab and have that category displayed and sorted by priority--and yet I can go to the main tab and sort ALL the tasks for creation dates and priorities.

But having multiple categories associated with a single task--and sorting--has me stumped. Any help would be greatly appreciated.

I have a lot of proj mgmnt experience and have found that the most important thing is to get the task(s) down on paper--first. I enter a task and upon hitting return the cell directly below the entered task becomes active-ready for entering the next task, and so on. I then go back and determine priority and category (or categories) for each task. Sure I have Outlook, Taskcoach, Project etc., but I like the flexibility of Excel plus...well you know why we all love it...