I'm new here, but I was looking for suggestions:

In excel I have a priority list column A is where my list is at. Is this a simple macro I can run if I wanted to move say priorit 10 above #5 than the macro could automatically sort column A back in order.


here's some sample data:

col A Col b Col C
Priority Name LGIC/MGA
1 Business Auto Rate Revision
2 Liab and Phys Dmg - ISO ATP P-Transit
3 Bond Filings LGIC
4 General Liability TCS