palanchino
New Member
- Joined
- May 25, 2015
- Messages
- 1
hello guys, I need your help
I have to take data from a pivot table that does not have a fixed number of columns (with the refresh of the data may increase or decrease) now my problem is that I can not give a dynamic range to my Vlookup, I tried with GetPivotData it works but if I change the city level are data of the previous one.
post here link at file for explaining the issue
https://docs.google.com/spreadsheets/d/1xt9RedXi4HHmYqcbwACH76B6-m0sSRnXbL9MqFaVm8c/edit?usp=sharing
thank you so much
Rocco
I have to take data from a pivot table that does not have a fixed number of columns (with the refresh of the data may increase or decrease) now my problem is that I can not give a dynamic range to my Vlookup, I tried with GetPivotData it works but if I change the city level are data of the previous one.
post here link at file for explaining the issue
https://docs.google.com/spreadsheets/d/1xt9RedXi4HHmYqcbwACH76B6-m0sSRnXbL9MqFaVm8c/edit?usp=sharing
thank you so much
Rocco
