Attempting to creating a prioritized "to do" list - Help!

M

Mike U.

I'm trying to figure out how to post a bulleted list of "to do" items into
excel that I can then prioritize and sort. An example follows

- Project "A" work
- Call Jerry K. to confirm transition to new phone system
- Migrate Customer List into SAP
- etc.
- Project "B" work
- Communicate leads information to field sellers
- Schedule review date w/vendor
-etc.

I'd like to be able to copy the example above from word and paste into Excel
as only two cells (Project A and Project B). I need to maintain the
hierarchical structure of the bullets and display all of the related task
items in a single cell. That way I can then assign a value to my list of "to
do's" and sort them by priority.

Any suggestions on how to do this would be appreciated.

Thanks!
 
N

Nick Hodge

Mike

Would it not be better to use two columns, say A and B as indexes. IE Column
A is the Project Letter and Column B the priority within that project. In
this way you would be able to sort by column A first and then column B,
sorting priorities within projects and also use Excels Subtotal or outline
function to count the tasks within a project and summarise them

Just a thought

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
M

Mike U.

Nick,

Thanks for your reply. I understand what you're suggesting although it would
require more work than necessary. I'm not looking to prioritize each activity
in project "A," I'm simply looking to rank the priority for the whole project.

I usually create these bulleted tasks in Word and would like to be able to
paste them into Excel, assign a rank to the entire task/project, and then
sort. The intent is to continue to be able to paste new tasks to the
spreadsheet over time and be able to resort as needed.

Any ideas?

Thanks
 
N

Nick Hodge

Mike

Can these tasks be set up in Word tables? I sense if you do it this way it
may be possible as Excel will recognise the table as a much more native
format

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
M

Mike U.

I've tried that, although when I paste the table into Excel, it still divides
the individual tasks listed in the Word table(Single cell) into multiple
cells in Excel.

Any other ideas?
 
Top