What I implemented in your file follows closely along the lines of another
recent post to Scott: http://tinyurl.com/auxdb

File has been sent (zipped) to you.

In Sheet: KeyOrder
----------------------
The 4 drivers' names are listed in BZ1:CC1
(no more formulas in BZ1:CC1)

Put in BZ3: =IF(ISNA($BW3),"",IF($BW3=BZ$1,ROW(),""))
Copy across to CC3, fill down to say CC199
(copy as far down as data is expected in col BW

I also copied pasted some sample data into A3:A50

In Sheet: Don
----------------
Put in A1: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
This will pull-in the sheetname into A1, but file must be saved first

Put in A3:
=IF(ISERROR(SMALL(OFFSET(KeyOrder!$BY:$BY,0,MATCH( $A$1,KeyOrder!$BZ$1:$CC$1,
0)),ROWS($A$1:A1))),"",INDEX(KeyOrder!A:A,MATCH(SM ALL(OFFSET(KeyOrder!$BY:$B
Y,0,MATCH($A$1,KeyOrder!$BZ$1:$CC$1,0)),ROWS($A$1: A1)),OFFSET(KeyOrder!$BY:$
BY,0,MATCH($A$1,KeyOrder!$BZ$1:$CC$1,0)),0)))
Copy A3 across to BY3, fill down to say, BY100

Then just duplicate sheet: Don, and rename with the other 3 drivers' names.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
Thank you for your support. We did not change our mind. Still need you
advice. will send you the file at the address show above.