Pivot table resize
Hello,
I am using Excel 2007 and I am doing a Vlookup from a pivot table.
Currently my Vlookup looks from sheet 2 starting from A1:G50, but here is my
problem the pivot table can grow (i.e. Al:G200) or shrink (i.e. A1:G25) How
can I adjust my Vlookup to look at the pivot that can shrink or grow
automatically. Any tips will be appreicated. Thank you in advance.
Cheers,
|