Delete matched items after advanced filter

croweld89 · May 9th, 2002, 02:02 PM

Years ago I knew how to do this, however, I've slept since then.

I have a list of multiple columns, used the advanced filter to match a single number in the table, and copied matches to another section in the worksheet.

Now, how do I delete the matched items from the original list. It seems that Excel had built in capabilities to do that, however, I can't remember where/how.

Thanks for the help.
-Dave

Mark W. · May 9th, 2002, 02:06 PM

Just select the visible rows in your AutoFiltered list and choose the Edit | Delete... menu command.

croweld89 · May 9th, 2002, 02:24 PM

If you copy rather than 'filter in-place' then excel does not hide non-matches.

Though, I could probably just rerun the filter in-place and follow your suggestion.

Are there any other suggestions?

Thanks
-Dave

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

May 9th, 2002, 02:02 PM	#1
croweld89 New Member Join Date: Mar 2002 Posts: 34	Years ago I knew how to do this, however, I've slept since then. I have a list of multiple columns, used the advanced filter to match a single number in the table, and copied matches to another section in the worksheet. Now, how do I delete the matched items from the original list. It seems that Excel had built in capabilities to do that, however, I can't remember where/how. Thanks for the help. -Dave

May 9th, 2002, 02:06 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Just select the visible rows in your AutoFiltered list and choose the Edit \| Delete... menu command.

May 9th, 2002, 02:24 PM	#3
croweld89 New Member Join Date: Mar 2002 Posts: 34	If you copy rather than 'filter in-place' then excel does not hide non-matches. Though, I could probably just rerun the filter in-place and follow your suggestion. Are there any other suggestions? Thanks -Dave