How to send filtered row to another location

[Vitas]

I search for data using autofilter 100 times per day. Each time when I get required position I have to copy that row to another sheet.
Is there any code to send that row to another location automaticaly?

 

[Mark W.]

Record a macro that uses an Advanced AutoFilter. See the Excel Help topic for "Filter a list by using advanced criteria".