How to send filtered row to another location

Vitas · Feb 28th, 2002, 07:38 AM

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. · Feb 28th, 2002, 07:42 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 07:38 AM	#1
Vitas New Member Join Date: Feb 2002 Location: Lithuania Posts: 9	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?

Feb 28th, 2002, 07:42 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Record a macro that uses an Advanced AutoFilter. See the Excel Help topic for "Filter a list by using advanced criteria".