In a meeting that determines what we work on first, we put our task into a speadsheet. during the meeting the spreadsheets gets updated, some tasked eliminated, some task are added and priorities of others are changed. What we currently doing is we give each task a priority number which might get changed after reviewing some of the other task. ie: if we have 50 tasked numbered and then a new task comes in and it's determined that it should be the top priority and given a 1, then we currently have to renumber the current 1 to 2, the current 2 to 3 and so on manually, then sort the data manually again.



Is there a way that if we change the number of a task, it renumbers the other task automatically? We can still do the sort manually. say for instance the number 25 task of the 50 task was changed to be the number 15 task, it would automatically change the old 15 to 16 and so on up to 50. task 26 - 50 shouldn't need to be changed. That would allow us to update a number of task then do a sort to see where we stand.

I'm not familiar with a macro option for this which I'm sure there would be and someone who is familiar with macros and automation I'm sure could help with this.

A temporary work around might be that when you add a new task, have your list in ascending order by priority number, so it will be listed from 1-50. Insert a new blank row above the task which has priority as 1, so at the top of the list. Put this new task as priority 1. Renumber only 1 to 2, 2 to 3, 3 to 4, 4 to 5 and then AutoFill the rest of the numbered down to 50. So you would only need to manually change the first 3 or 4, then highlight that number sequence and AutoFill down and Excel will continue the number pattern.

I'll give that a try and see what I can come up with. Thanks for your help!