holycome99
New Member
- Joined
- Nov 16, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
My table have many kind of food, almost each have different name
like this.
But what i wanted to do is that to filter out that "-"
I tried to run macro that use autofilter to include all the name except "-"
However, once i update the table (More and more different kind of food),
the new food will be kicked out also!
ActiveSheet.ListObjects("Diet").Range.AutoFilter Field:=4, Criteria1:=Array _
("Banana", "Curry Rice", "Hot Dog", "Noodles"), Operator:=xlFilterValues
Probably is that the macro won't be up-to date when i update new food to table
How can i only kicked "-" out but without kicking other new food name?
Thank u much!
like this.
But what i wanted to do is that to filter out that "-"
I tried to run macro that use autofilter to include all the name except "-"
However, once i update the table (More and more different kind of food),
the new food will be kicked out also!
ActiveSheet.ListObjects("Diet").Range.AutoFilter Field:=4, Criteria1:=Array _
("Banana", "Curry Rice", "Hot Dog", "Noodles"), Operator:=xlFilterValues
Probably is that the macro won't be up-to date when i update new food to table
How can i only kicked "-" out but without kicking other new food name?
Thank u much!