Just sort your table on the Task column.

Regards,
Fred

"crj" wrote in message
...
I have a sheet that contains 20 tasks that have a column that ranks their
priority 1 thru 20. I need to be able to take task 15 and change the
priority
to 3. When the priority changes I want task 15's row to become new row 3;
old
row 3 needs to become row 4 and the priority in old row 3/new row four
needs
to be changed to 4; ... and so on until row 14 becomes row 15 with a
priority
of 15.

Any ideas on how to accomplish this?