Date Grouping Issue

R

richod

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot ungrouping on refresh? 3
grouping multiple tables Excel 2007 3
Pivot table date grouping 2
date filter in a pivot table 1
Excel Macro to copy a row to another sheet based on date 0
convert date to text month 2
Pivot table grouping excluding weekends 4
filtering dates in a Pivot Table Report Filter 3

Top