L
LB79
Hi - does anyone know a piece of code that will change the range m
pivot table reads from?
Thank
pivot table reads from?
Thank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
You can use the offset function to accomplish this. There is a lot of good
help on this throughout the discussion group and on Debra’s site
http://www.contextures.com (where I first learned about it)
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),2)
-The COUNTA(Sheet1!$A:$A) will adjust the number of rows for the table as
new data is added.
- You can change the 2 to the number of columns in your pivot table source
data. For example if your data had 15 columns in it then change the 2 to 15.
Optionally, if the number of columns will also change then change the 2 to
this COUNTA(Sheet1!$1:$1).
Hope this helps.
help on this throughout the discussion group and on Debra’s site
http://www.contextures.com (where I first learned about it)
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),2)
-The COUNTA(Sheet1!$A:$A) will adjust the number of rows for the table as
new data is added.
- You can change the 2 to the number of columns in your pivot table source
data. For example if your data had 15 columns in it then change the 2 to 15.
Optionally, if the number of columns will also change then change the 2 to
this COUNTA(Sheet1!$1:$1).
Hope this helps.
G
Guest
Sorry, the full link to get to the correct page
is:http://www.contextures.com/xlNames01.html
is:http://www.contextures.com/xlNames01.html
L
LB79
Thanks for that formular.
Do you know if there is a way to do it in VBA
Do you know if there is a way to do it in VBA
G
Guest
I am sure there is, I don't know much about VBA. I have just started to
learn a little bit about VBA myself. You may want to try posting this in the
programming group.
learn a little bit about VBA myself. You may want to try posting this in the
programming group.