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!