Help with Dynamic Range and Pivot Table

[spectraflame]

I am using the following named range to selet the desired data to represent in a pivot table.

=OFFSET('MISO SUMMARY'!$A$7,0,0,COUNTA('MISO SUMMARY'!$A:$A),6)

The data starts in A7 and goes to column F. When I select the range and it is highlighted, there are 4 extra rows that are blank that are included in the range. I think this may be throwing off my pivot table becase if I create a pivot table using the named reference, I cannot group any information. However if I manually define my range, the pivot table works fine.

Any ideas?
Matthew

 

[Norie]

Matthew

Do you have any formulas in column A that are maybe getting counted with COUNTA?

 

[spectraflame]

Column A contains a date. Columns B-F contain VLOOKUP statements that return values from other sheets within the same workbook based on that date.

For testing, I moved the data up to cell A1 and the dynamic range worked correctly?

I am problably going about this all the wrong way. The chart that I am generating the pivot table from is a summary to other sheets. I should probably be creating the pivot table directly from the data on the multiple sheets, but I have not had much luck with that either.

Matthew