Filtering

Mar 4th, 2002, 01:56 PM

I have a large list of entries (>2500). I would like to be able to search a column for a particular reference number, say 04800-00. This number may appear by itself in a cell, or as part of a list of numbers in a cell. Is there a way to get a macro that will prompt me for a value, search for that value, and then only display those entries with that number (like a filter)?

jeffmfrank · Mar 4th, 2002, 02:09 PM

You should be able to use the advanced autofilter command. Follow the rules Excel's help to use it. It's pretty cool since it hides the rows that you filter out.

Paul-Johnson · Mar 4th, 2002, 06:00 PM

I ues advanced filtering on 35000 + rows. If you need any help, drop me a note.

PJ

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

Mar 4th, 2002, 01:56 PM	#1
Guest Posts: n/a	I have a large list of entries (>2500). I would like to be able to search a column for a particular reference number, say 04800-00. This number may appear by itself in a cell, or as part of a list of numbers in a cell. Is there a way to get a macro that will prompt me for a value, search for that value, and then only display those entries with that number (like a filter)?

Mar 4th, 2002, 02:09 PM	#2
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	You should be able to use the advanced autofilter command. Follow the rules Excel's help to use it. It's pretty cool since it hides the rows that you filter out.

Mar 4th, 2002, 06:00 PM	#3
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	I ues advanced filtering on 35000 + rows. If you need any help, drop me a note. PJ