Hello again
This is my second post trying to resolve this issue, hopefully I explain it better this time and can get some help.
I'm trying to filter on certain criteria for my pivot table and want to reference a particular set of cells.
Here is the code I got when I recorded my macro and manually filter:
Range("C1").Select
ActiveSheet.Range("$C$1:$D$28").AutoFilter Field:=1, Criteria1:=Array("1", _
"3", "YTD", "Z56"), Operator:=xlFilterValues
Instead of referencing "1" or "3", I'd like to reference the value in Cell A2 and A3 so that I can change the cell value and the pivot picks up the new value.
<TBODY>
</TBODY>
I'll keep working on it, but if someone could help point me in the right direction I'd be a very happy camper.
Thank you
Greg
This is my second post trying to resolve this issue, hopefully I explain it better this time and can get some help.
I'm trying to filter on certain criteria for my pivot table and want to reference a particular set of cells.
Here is the code I got when I recorded my macro and manually filter:
Range("C1").Select
ActiveSheet.Range("$C$1:$D$28").AutoFilter Field:=1, Criteria1:=Array("1", _
"3", "YTD", "Z56"), Operator:=xlFilterValues
Instead of referencing "1" or "3", I'd like to reference the value in Cell A2 and A3 so that I can change the cell value and the pivot picks up the new value.
Ref Cells | Week | Dollars | State |
1 | 1 | 10 | Tx |
3 | 1 | 10 | Tx |
Z56 | 2 | 15 | Tx |
YTD | 2 | 15 | Tx |
3 | 20 | Tx | |
3 | 20 | Ca | |
4 | 25 | Ca | |
4 | 25 | Ca | |
YTD | 30 | Ca | |
YTD | 30 | Co | |
Z56 | 100 | Co | |
Z56 | 100 | Co |
<TBODY>
</TBODY>
I'll keep working on it, but if someone could help point me in the right direction I'd be a very happy camper.
Thank you
Greg