Can I set up one datarange (i.e. all the data in worksheet 1) that all my pivot tables call to? thx
J Joyce May 23, 2005 #1 Can I set up one datarange (i.e. all the data in worksheet 1) that all my pivot tables call to? thx
D Debra Dalgleish May 24, 2005 #2 You could use a dynamic range as the pivot source, and refer to the range name in the code. There are instructions here: http://www.contextures.com/xlPivot01.html
You could use a dynamic range as the pivot source, and refer to the range name in the code. There are instructions here: http://www.contextures.com/xlPivot01.html
