Filtering out specific values from a table

[armando12345]

Hi All,

This is just a generic question about filtering a table. Is it possible to filter on a condition?

For example:

I have a field named primary key and I want to filter all primary keys that are > 990000. Is that possible? Would the key have to be formatted as a number?

[Keebellah]

Hi, have you even taken a look at filtering or trying something?
You can find many links if you google, one of these https://www.xelplus.com/excel-filter-basic-to-advanced/
And there are many many more.

[armando12345]

Sorry. I meant using vba

[Keebellah]

You can star by recording a macro while you set the filter.
After you stop the macro recorder you can look at the code and see how it's done, there will be a lot of extra code that van be removed but the basics you can see and use and reuse.
When you get stuck attach what you have with dummy data with the idea you have and what you want on the sheet, makes it easier to help and understand