justme
Well-known Member
- Joined
- Aug 26, 2002
- Messages
- 729
What I have is a list of items which are ranked in ascending order in column C. What I want to do is to be able to easily add line items that would require a mass re-ranking of the items which come after it.
The rows are not [necessarily] in ascending order by rank.
I would like to press a button that says re-rank. Then an input box would come up and say something like what items need to be re-ranked? and then I would enter the rank of the new line item - say it is number 5. Now all the existing line items that are ranked 5 or higher will increase in value by 1. Is this possible?
There are rows with no information that will be in the worksheet, so if there is no info in column c it should remain blank.
I hope this is a little clearer than mud....
The rows are not [necessarily] in ascending order by rank.
I would like to press a button that says re-rank. Then an input box would come up and say something like what items need to be re-ranked? and then I would enter the rank of the new line item - say it is number 5. Now all the existing line items that are ranked 5 or higher will increase in value by 1. Is this possible?
There are rows with no information that will be in the worksheet, so if there is no info in column c it should remain blank.
I hope this is a little clearer than mud....