I get the data by dates. (month, day, year).

1) a) I want to be able to take it to a pivot table and have the column by month within a year.
b) Also, how do I do the same function using the sumproduct function.


2) Once I have that data I want to be able to take it into a fixed (non-pivot table report) and plug in the info my month and year. the problem in this step is that the data does not contain always every single month so the pivot table does not have all the months and years.
Also, how do a link the month March 2008 to the fixed cell in my final report March 2008, if the pivot table is dynamic and I do not know in what cell the information will appear.