Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP a Pivot Table Filter
Good day,
I use a corporate phone switch report to pull data and users' phone usage (ie how much time logged in, how much talk time inbound, outbound, etc). I end up dumping data from 4 sources in 4 seperate tabs. All tabs build a full data table, which then generates 5 pivot tables (based on 5 individual weeks worth of data). My issue is currently I have to adjust the pivot table filters manually whenever I want to display a different week. I would like to have these filters auto-adjust by using a VLOOKUP function. There is an area which allows the admin user to select which month to display, and populates the 5 week numbers and their Monday's date. I want the filter sections of the pivots to pull those week numbers. Essentially - instead of going into the filter and selecting week # 40, 41, etc, I would like to have a =VLOOKUP("Week 1",'Sheet1!A:B',2,0) Any thoughts? Bare in mind I am no good with advanced VB coding Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - Filter - no filter by value | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
filter on pivot table | Excel Discussion (Misc queries) |