To create a dynamic range that counts the rows and columns:
=OFFSET(Data!$A$10,0,0,COUNTA(Data!$A:$A),COUNTA(D ata!$10:$10))
That assumes there's nothing above or below the date in column A, or to
the right of the data in row 10.
Also, your headings should be in row 10, and there should be an entry in
each heading cell.
dab4211 wrote:
I am using Excel Pivot Tables Recipe Book by D. Dalgleish and am in chapter
7, €śUpdating a Pivot Table€ť. The data source for the pivots always begins in
cell A10. Column BL is always the last column, but the number of rows will
vary. The data are updated monthly. I followed the steps for naming the
data range using A10 instead of A1 as the starting place, but when I try to
use the named range for the data source for my pivot table, I get an error
message stating €śReference is not valid€ť. I am using Excel 2003. Any
suggestions?--
dab4211
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html