VBA - Count filtered rows in the table

[DocAElstein]

I don’t see any Excel Filters in the worksheet ( These things are what I think are Excel filters: https://support.microsoft.com/en-us/...6-38c37dcc180e ) ?

But I can probably do the whole thing with VBA, and forget all about filters.

So for example..
You type in
rr

rr.JPG




Then VBA will tell you this
Harrison Irwin
Sierra Howe
Curran Herring
Blake Herring
Jarrod Mccarthy
Or it will tell you anything else , like you asked for, Total rows , how many left etc. etc.

Probably that is what you want anyway, because you said ... I don't need filtered table but I need result table….

So I will make a start and then give you something, then we can take it from there any modify to suit you….

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA