Dynamic Ranges

montrof
montrof used Ask the Experts™
on
Hi all,
I want to use dynamic range to define the data for a pivot.  The issue is I am having is how do I make the formula so that if number of rows and column could change it would update.  The data starts on A1 and goes to R1533 currently but it could change to T1615 or anything. Your help would be greatly appreciated.

Montrof
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
montrof,

I address how to do this in my article here:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_3172-How-to-Automatically-Update-Your-PivotTables-and-PivotCharts.html

It shows how to make the source range dynmaic, either by using a Table (Excel 2007/2010), or by using a dynamic named range (any version of Excel).

Patrick

Author

Commented:
Thank you that worked great I used the table method.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial