software

Hi all, I searched but couldnt find an answer to this problem.
I have a lot of items that are serial numbered, the portable scanner drops
the serial numbers into column A with no problem at all. Then I need pass or
fail to show in column F. This is no problem at all either (because I learnt
from previous threads).
My problem is that the items are scanned numerically randomly and passed or
failed, but when I sort column A into ascending numerical value, column F
value doesnt move to the new row that the column A value moves to.

EG,
A B thru E F
2 details Pass
1 details Fail

and when I sort it all I end up with

A B thru E F
1 details Pass
2 details Fail

instead of

A B thru E F
1 details Fail
2 details Pass
How do I make the result in column F follow/sort with that of column A????This is the smartest forum I have encountered for a long time, Im sure
someone can help.
Thankyou

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...tions/200604/1

What formulas do you have in columns B thru F ?

--
AP

quot;outwest via OfficeKB.comquot; lt;u19594@uwegt; a écrit dans le message de
news:5ee8c7736fb52@uwe...
gt; Hi all, I searched but couldnt find an answer to this problem.
gt; I have a lot of items that are serial numbered, the portable scanner drops
gt; the serial numbers into column A with no problem at all. Then I need pass
or
gt; fail to show in column F. This is no problem at all either (because I
learnt
gt; from previous threads).
gt; My problem is that the items are scanned numerically randomly and passed
or
gt; failed, but when I sort column A into ascending numerical value, column F
gt; value doesnt move to the new row that the column A value moves to.
gt;
gt; EG,
gt; A B thru E F
gt; 2 details Pass
gt; 1 details Fail
gt;
gt; and when I sort it all I end up with
gt;
gt; A B thru E F
gt; 1 details Pass
gt; 2 details Fail
gt;
gt; instead of
gt;
gt; A B thru E F
gt; 1 details Fail
gt; 2 details Pass
gt;
gt;
gt;
gt; How do I make the result in column F follow/sort with that of column A????
gt;
gt;
gt; This is the smartest forum I have encountered for a long time, Im sure
gt; someone can help.
gt; Thankyou
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...tions/200604/1
Hi Ardus,
B thru E just has details of size, shape etc that are sourced from another
sheet, sheet 2 in this case, it is called editor.
The formulas in sheet 1 B thru E read like
Column B =editor!(b2) Column C =editor!(c2) etc
The results in B thru E will auto sort themselves as Column A is sorted in
ascending value.
The result in column F (pass or fail) is input by the barcode scanner after
the operator scans the serial number and assesses the item.

I basically need to quot;lockquot; A and F together so they move as one.

Thanks for taking an interest

outwest wrote:
gt;Hi all, I searched but couldnt find an answer to this problem.
gt;I have a lot of items that are serial numbered, the portable scanner drops
gt;the serial numbers into column A with no problem at all. Then I need pass or
gt;fail to show in column F. This is no problem at all either (because I learnt
gt;from previous threads).
gt;My problem is that the items are scanned numerically randomly and passed or
gt;failed, but when I sort column A into ascending numerical value, column F
gt;value doesnt move to the new row that the column A value moves to.
gt;
gt;EG,
gt;A B thru E F
gt;2 details Pass
gt;1 details Fail
gt;
gt;and when I sort it all I end up with
gt;
gt;A B thru E F
gt;1 details Pass
gt;2 details Fail
gt;
gt;instead of
gt;
gt;A B thru E F
gt;1 details Fail
gt;2 details Pass
gt;
gt;How do I make the result in column F follow/sort with that of column A????
gt;
gt;This is the smartest forum I have encountered for a long time, Im sure
gt;someone can help.
gt;Thankyou

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...tions/200604/1