VBA Pivot Table fixed Row Fields

I have a master report that I update using data from another excel daily report that has the data organized via a pivot table. Some of the row fields that have pivot data are not constant from day to day. It would be great to run the pivot and include data as a row field that is not actually in the daily report. Is there a way to do this? it would make things easier when copying the data to the master report.

example:

Daily report:

Day 1
black 5
blue 5
red 4
green 3

Day 2
black 4
red 2
green 1

Day 3
Black 2
Blue 1


Master:
Day1 Day2 Day 3
Black 5 4 2
Blue 5 0 1
Red 4 2 0
Green 3 1 0

Would like the daily report to show all colors if there is data or not.

Does the attached work for you?

Originally Posted by MarvinP

Does the attached work for you?

Thanks for the reply and the help.
However, the data will not in one file but a separate file each day.
I would like all the items to show on each days pivot to make copying and pasting into the master report easier.

For example, when I run the daily report for day 3, all the items will be in the pivot but only 2 will have data (black and blue.)

I'd copy the daily data into a master file and run the pivot table on it daily.

Originally Posted by MarvinP

I'd copy the daily data into a master file and run the pivot table on it daily.

The actual daily file has several hundred rows. During the course of a month, it turns into a few thousand.

I have a pivot table dealing with over 100,000 rows. It collects water meter reading from 137 homes, 4 times a day. We've collected data since Nov 2009.

If you have a few hunded rows a day and start again each month, you are fine. The more data the more effective pivot tables are.