I am trying to use pivot table data outside of the table and I when I drag
the info from one line to the next, the pivot table information stays
constant. I would like it to pull from B2 to B3 to B4 and so on instead of
b2 to b2 to b2.