Hi

It'll be best, to enter all data into single sheet - you even don't almost
need to redesign anything. Maybe only instead of Status implement a Repaired
column, where the date when vehicle was repaired is entered. I.e. something
like
sheet Workshop: EntryID, Vehicle, DateIn, DateRepaired, DateOut, ...

Now you can relatively easily design a couple of report sheets, where on any
of them you determine some criteria, and a report based on those criteria,
and on data from sheet Workshoop, is displayed. Like:
- The list of vehicles, currently in workshop;
- The list of vehicles, being in workshop on selected date;
- The list of vehicles, taken into workshop on selected date;
- The list of vehicles, which were in workshop during determined time
interval (p.e. during selected month or year);
- The list of repairements for a determined vehicle;
etc.

On workshop sheet, I advice you to use FreezePanes and Autofilter features.
It allows easily to find wanted entry, or to hide old entries. For some
cases, Autofilter can be a replacement for a report.

You can delete old entries (deleting whole row) periodically, or, when you
want to preserve them, you can keep the workbook for year or month (it
depends on how much entries you'll have - a couple of thousands is OK,
~10000 will cause the workbook to be too slow). When preserving old data,
you rename old workbook with a name indicating period (like
Workshop2005.xls), and clear all old data from original one (Workshop.xls).
You have to consider, how to handle entries, which were taken in in one
period, and were taken out in another - or you have double entries for them
in both workbooks, or you mark them as taken out on last day in archived
workbook, and as taken in on 1st day in current one.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"cjjoo" wrote in
message ...

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