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?