• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Dynamic Ranges

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
0
montrof
Asked:
montrof
1 Solution
 
Patrick MatthewsCommented:
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
0
 
montrofAuthor Commented:
Thank you that worked great I used the table method.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now