I think the title of this post is confusing, but I couldn't figure out a better way to word it.
Here's what I'm trying to do:
1. I'm building a macro that will always filter out certain pieces of data (always in Column B), and put the remaining data into a new tab on the spreadsheet. Once that's done, it will move back to the first Tab and un-filter the data. The problem I'm running into is that while I know which column fields will always need to be REMOVED, I DON'T necessarily know what fields will always need to be RETAINED (as new types of entries might be created or discovered).
I'm finding that the Macro I've built consistently removes what I want it to, but if there's anything that's never been entered into the spreadsheet before, it will filter out as that as well (which I don't want it to).
I guess what I'm trying to say is that the Macro I've built seems to know exactly what items to KEEP, when I need it to know exactly what items to REMOVE.
Here's what I'm using:
' MacroTest Macro
'
'
Columns("A:C").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$C$7").AutoFilter Field:=2, Criteria1:=Array( _
"Debit Card Purchase", "Pre-Auth Debit", "="), Operator:=xlFilterValues
Rows("1:15").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Range("C18").Select
Sheets("Sheet1").Select
ActiveSheet.Range("$A$1:$C$7").AutoFilter Field:=2
Range("H20").Select
Thanks in advance for everyone's help:
Bookmarks