Hi,

I’ve got a task list in column A and a priority list in column B. When I finish one of the tasks, I put ‘Done’ in column B next to the task. I’m looking for the best way to reprioritize the rest of the column (i.e., when I finish the priority 1 task, priority 2 becomes Priority 1, priority 3 becomes priority 2, etc.). The column will obviously have numbers and the word ‘Done’ in cells, so there are two different data types. I’m thinking the best way would be with VBA, but there may be an easier way with a helper column with formulas. I appreciate any help and guidance. Thanks.

Frank