software

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: www.excelforum.com/member.php...oamp;userid=31293
View this thread: www.excelforum.com/showthread...hreadid=509666Maybe using a dynamic range would work?

www.contextures.com/xlNames01.html#Dynamic

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;richodquot; gt; wrote in
message ...
gt;
gt; I am trying to use pivot tables with an automated refresh of data. I
gt; want to report on all data in every column and row (Example
gt; Sheet1!$A:$D).
gt;
gt; The issue I have is I want to group my dates but receiving error since
gt; not all rows in the selection have dates in them since some rows are
gt; blank based on selecting the entire column. However, I will never know
gt; how many rows will be returned from the automated refresh.
gt;
gt; Is there a way to dummy the date field automatically, filter out blank
gt; dates, or automate the selection of only rows which have data, so
gt; grouping can still occur.
gt;
gt;
gt; --
gt; richod
gt; ------------------------------------------------------------------------
gt; richod's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31293
gt; View this thread: www.excelforum.com/showthread...hreadid=509666
gt;