this is my problem:


i got 30 worksheets in a workbook and they are named 1-31( according to
the
day of that month)

the format of each worksheet is the same and they look like this:

unique id vehicle num date in date out status(can input either "ok"
or "not

ok" )

so in sheet 1 ,(day 1) two vehicles( no x123 and y456) comes into the
workshop.

x123 is repaired and the status will be key in as "ok"
y456 is not repaired and the staus will be key in as "not ok"

now, in day two(sheet 2), i want to return the vehicle no, the unique
id of y456

that is still in the workshop automatically . Is that possible?

The unqiue id comes from the concatenuate of the vehicle no and the
date in

i tried to use vlook up but the results are not desired.

pls advise...


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=476166