ExcelBanter - Setting a datarange

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Setting a datarange (https://www.excelbanter.com/excel-discussion-misc-queries/27379-setting-datarange.html)

Joyce

Setting a datarange

Can I set up one datarange (i.e. all the data in worksheet 1) that all my
pivot tables call to?

thx

Debra Dalgleish

You could use a dynamic range as the pivot source, and refer to the
range name in the code. There are instructions he

http://www.contextures.com/xlPivot01.html

Joyce wrote:
Can I set up one datarange (i.e. all the data in worksheet 1) that all my
pivot tables call to?

thx

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 04:28 AM.