Initially, I have a prioritized table that would enable a user to change the priority of a row based on its importance. For example, I was envisioning a data validation drop down list containing the numbers 1-n where n is the dynamic number of rows in the table, and where 1 =highest importance, etc.
If I change the priority 1 to 5, then the priorities for the remaining rows will shift up by one.
Subsequently, the row with priority 2 will now have priority 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, I can just manually resort it using the header filter dropdown.
TIA!!
Bookmarks