In this workbook, I choose which parts I need (rows), and I place the number needed in column "R". After I enter the number needed in this column, I run a "sheetstats" macro that looks at the parts I have chosen and provides totals and other info about the parts chosen.
Before placing these quantities in column "R", I use the autofilter to gradually pick and choose parts based on the various critieria. In order to run my "sheetstats" macro, however, the filters are cleared as this macro releases them in order to make calculations.
I was wondering if there were a way to run the "sheetstats", but also see the filters that were used to make my choices.
I guess and alternative way to achieve this would be to write the "sheetstats" macro in a way that doesn't require the release of the filters, but I really don't know how.
Bookmarks