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