VBA - Count filtered rows in the table

[sandy666]

each filter filters the values of the remaining rows and not all, only the first filter filters the total (100).
you can test it using only the last filter with the rest left blank (don't know if it will work on xl2013)




hope it's clear now

more options



or



you insisted on showing the filter results and I don't want it, maybe this description will be better: filter1 - show count filtered1 rows AND count left rows after filter1, then filter2 shows count rows from left rows after filter1 - it will be count2 filtered and left2 after filter2 , and etc

[DocAElstein]

....you can test it using only the last filter with the rest left blank (don't know if it will work on xl2013)....

As far as I am aware, nothing does anything on your file if I download it as you said and then open it. But maybe I don’t know what to do to make anything happen if it has something to do with making PQ do something.
But that is not important.
I think I am closer now to understanding . ( Probably some of the problem for me was/ is that I never did anything with filters so I did not know that for example “filter by rr” or “filtered by rr” means “remove all lines in table where in column name, the name contains rr”
- It’s obvious with hindsight, but then usually everything is.)

---

I will have another go and post again later with it.

_ (I will always need the table, the full table, and also the filtered tables as I go along. Maybe the full table and all the others could be put in a spare third worksheet. I can get the full table from the csv file with VBA, but I expect you can get it better with PQ)

_ The table can be any size, any number of rows and columns.

_ You don’t want the full table at all. And I don’t particularly want it on the first worksheet.
I suggest
First worksheet is for filter tables
Second worksheet is Results
Third worksheet has full table and any other shit that my coding would need. (But maybe later we can do without it.**)

But you can suggest something else if you like.
I could get the coding to work on the csv file, and so the full table would never be in the Excel file, but that would be more complicated and it would also make it difficult to develop the coding and check and fix any mistakes initially.
**Maybe later when you are happy that everything is working as you want, then later I could modify the code to work only on the csv file, so then you would never see the full table or filtered tables ever in Excel