How do I create an auto prioritized table ?
Is it possible to create an auto priority column in a table list? Initially, I have a priority list column in one of my lists that have the users changing the priority of an item based on its importance. This can be changed whenever the priority of an item changes. I was envisioning a data validation list. So, for example, I have a drop down that allows the users to select a number ie. (1 – 100). If they select 1 its an high importance, etc. If say for example that priority changes and the user changes it from 1 to 5, then Items will shift up a priority. So the row with priority 2 will move to 1, 3 to 2, 4 to 3, 5 to 4? Ideally, the rows of the table will rearrange based on the new priority, but if that requires code; otherwise I can manually resort later.
This has been answered here… http://www.excelqna.com/question/how-to-auto-sort-rows-by-a-ranked-column-in-excel/
See if this helps.