[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • 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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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