Posted on 2011-09-02
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.