You've also not said how you want to modify the priority? Are we to use
atmospheric extrapolation (pulling it out of thin air).

Barb Reinhardt

"Alonso" wrote:

Another possibility it's a button somewhere in a cell of a row
to move the entire row
either up
(ie. row 6 cut, insert between row 4 and 5, so it becomes the "new" row 5)
or down
(ie. row 5 cut, insert between row 6 and 7, so it becomes the "new" row 6)

I don't know really
just thinking aloud...
whatever that means

ha ha ha


"Alonso" wrote:

Oops..

well
here i go again

right now, I assing the numbers manually
(in your example, suppose that in C10 I insert a 2
in C23 a 4
in C32 a 1
and so on)
then sort by machine, work and priority
but that in done with the info listed

what i want/need
it's to somehow modify the priority numbers
either by a macro
or formula

new data could be added
AT THE END
and some rows could possibly desapear
so, I need that the macro or formula
could assing/moddify the priority number in column C as well


better??
=P


"Sheeloo" wrote:

No you have not :-)

Suppose you have five rows for Machine 1 Work 1, say in row 10,23,32,54,56,
how will you assign the nos?
Then suppose you enter the same combination Machine 1 Work 1 in say row 70?
What would you like to do?
Will you ever insert BEFORE the existing row? Will you delete rows....