I am not sure if this can be done.
I have a database in excel that tracks certain equipment inventory and
maintenance .

worksheet 1 looks like this:
Truck # Station Location code # Status DATE
450 Millersville dw56 repair 10/3/06
451 Tioga dw63 inventory 10/1/06
452 Baltimore dw78 repair 9/30/06


I would like for any thing that has Status = repair to automatically go into
worksheet#2. Also in worsheet 1 there are drop down lists for the truck,
Station location, and Status (not sure if that effects what I want to do).
Any help is greatly appreciated.
thanks