I am trying to use pivot tables with an automated refresh of data. I
want to report on all data in every column and row (Example
Sheet1!$A:$D).

The issue I have is I want to group my dates but receiving error since
not all rows in the selection have dates in them since some rows are
blank based on selecting the entire column. However, I will never know
how many rows will be returned from the automated refresh.

Is there a way to dummy the date field automatically, filter out blank
dates, or automate the selection of only rows which have data, so
grouping can still occur.


--
richod
------------------------------------------------------------------------
richod's Profile: http://www.excelforum.com/member.php...o&userid=31293
View this thread: http://www.excelforum.com/showthread...hreadid=509666

Maybe using a dynamic range would work?

http://www.contextures.com/xlNames01.html#Dynamic

--
Regards,

Peo Sjoblom

Portland, Oregon




"richod" wrote in
message ...

I am trying to use pivot tables with an automated refresh of data. I
want to report on all data in every column and row (Example
Sheet1!$A:$D).

The issue I have is I want to group my dates but receiving error since
not all rows in the selection have dates in them since some rows are
blank based on selecting the entire column. However, I will never know
how many rows will be returned from the automated refresh.

Is there a way to dummy the date field automatically, filter out blank
dates, or automate the selection of only rows which have data, so
grouping can still occur.


--
richod
------------------------------------------------------------------------
richod's Profile:
http://www.excelforum.com/member.php...o&userid=31293
View this thread: http://www.excelforum.com/showthread...hreadid=509666