I don't even know where to begin searching for a solution to this, so hopefully someone can point me in the right direction.
I have a bunch of records consisting of a date, an account and a value. Once my code filters the list for the date period I'm interested in, I'd like to then filter the remaining results by account, then transfer that account name and its SUBTOTAL(9,xxx) value to another sheet. How can I get the code to step through each unique account? In one period I may have accounts X, Y, and Z, but another period it may just be X and Z, or A, B and C.
I guess I need something along the lines of:
For each unique value in filtered list
Filter further for unique value #1
Copy unique value #1 and it's SUBTOTAL value to Report sheet
Next unique value
Hopefully that explanation makes sense.
Thanks.
I have a bunch of records consisting of a date, an account and a value. Once my code filters the list for the date period I'm interested in, I'd like to then filter the remaining results by account, then transfer that account name and its SUBTOTAL(9,xxx) value to another sheet. How can I get the code to step through each unique account? In one period I may have accounts X, Y, and Z, but another period it may just be X and Z, or A, B and C.
I guess I need something along the lines of:
For each unique value in filtered list
Filter further for unique value #1
Copy unique value #1 and it's SUBTOTAL value to Report sheet
Next unique value
Hopefully that explanation makes sense.
Thanks.