M
Matt S-J
Good day,
I use a corporate phone switch report to pull data and users' phon
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 buil
a full data table, which then generates 5 pivot tables (based on
individual weeks worth of data).
My issue is currently I have to adjust the pivot table filters manuall
whenever I want to display a different week. I would like to have thes
filters auto-adjust by using a VLOOKUP function.
There is an area which allows the admin user to select which month t
display, and populates the 5 week numbers and their Monday's date.
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
I use a corporate phone switch report to pull data and users' phon
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 buil
a full data table, which then generates 5 pivot tables (based on
individual weeks worth of data).
My issue is currently I have to adjust the pivot table filters manuall
whenever I want to display a different week. I would like to have thes
filters auto-adjust by using a VLOOKUP function.
There is an area which allows the admin user to select which month t
display, and populates the 5 week numbers and their Monday's date.
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