VBA advanced filter
 

Hello,

I have a macro running that filters the data on one worksheet
(invoice_tracking) and then parses it out to the other worksheets (each
representing an individual task) according to task number.

My most recent quest has been to further parse out the data that is pasted
on each of the worksheets from the invoice_tracking worksheet to analyze
subtotals of invoices according to status (i.e. "APPROVED/POSTED",
"UNAPPROVED/WAITING", AND "APPROVED/NOT POSTED"). Ultimately, I need to be
able to total each category, pull that task's estimate amount from a cell on
the same worksheets, then analyze the variance according to status totals
(and grand total) vs estimate.

I tried to achieve this using VBA to do an advanced filter on the previously
filtered data for each worksheet. But it only gave me a value of the total
dollar amount for whichever status came first on the list. It wouldn't pick
out the unique records and just tally those.

Is there a way to do what I'm wanting to do in VBA? I'm wondering if the
advanced filter may not be capable of that level of fidelity. Maybe there's
some other method?

I tried doing a pivot table but could only get it to tally the invoices
along with the estimate --not find the difference between the value of the
different invoice statuses and the estimate.

Any insight would be ever so greatly appreciated.