Delete matched items after advanced filter

[croweld89]

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.]

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

 

[croweld89]

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