Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving filtered data between worksheets automatically
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Moving data between worksheets ... | Excel Discussion (Misc queries) | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |