JBuckley2000
Vendor
Hello everyone,
I am trying to do some ranking of tasks and setting priorities for when incoming shipments need to be paid. I want my columns to automatically change sorting preferences when I change the priority - let's same Shipment1 can be ranked lower than Shipement8. I want to put a "1" into Shipment8's priority column, which would then recalculate all of the other shipment's priorities and ensure there were no numbers that would be repeated. Shipment1 would then be "2", Shipment2 would be "3" and so on.
I know I can always resort this myself, but would there be a way to have Excel automatically resort the new priorities?
Does any of this make sense?
Thanks for the help.
JSF
Jason Facey
jfacey@lithonia.com
I am trying to do some ranking of tasks and setting priorities for when incoming shipments need to be paid. I want my columns to automatically change sorting preferences when I change the priority - let's same Shipment1 can be ranked lower than Shipement8. I want to put a "1" into Shipment8's priority column, which would then recalculate all of the other shipment's priorities and ensure there were no numbers that would be repeated. Shipment1 would then be "2", Shipment2 would be "3" and so on.
I know I can always resort this myself, but would there be a way to have Excel automatically resort the new priorities?
Does any of this make sense?
Thanks for the help.
JSF
Jason Facey
jfacey@lithonia.com