Automatically sort and re-order?

Hi there,

I have a spreadsheet where column c is for a Priority. We want to put a number in there to represent the priority order that this item will be worked on. We want to number them such as 1, 2, 3, 4....20. However, if I want to change the number of one of these items, I would like it to automatically re-sort the rows according to this new number. I also do not want any duplicates, so I am unsure how to do this.

Any help would be awesome!!

Carrie

This auto-sort routine notes any duplicates and asks the user to resolve them at the time of entry. It maintains column C to be 1,2,3,4,...,n.

in the Sheet's code module

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

Hi,

Just out of interest, what's the VBA instruction "Rem sort range" and "Rem re-number 1 to n"? I've not come across this before.

Is 'Rem' a VBA keyword new to Excel 2007, and what's the syntax? I note there are spaces in the characters following the Rem.

Rgds

Rem is an old school indicator for a comment.
I understand that folks with better eyes than mine can see the apostrophy that is being introduced as an alternate syntax for comments.

I'm having trouble downloading that file, it gets to 67.7 KB and stalls.

Yes, attaching zipped files is probably best.

I've adjusted the code to your data lay-out.
To move the routine to the Simulations page, all that needs to be done is exchange this line at the start of the routine.

Please Login or Register  to view this content.

This is a pretty volitile way to move data around, so I included an undo. Type "UNDO" into any cell in the priority column and the last re-ordering will be un-done.