Ok I've been working on this for awhile and I was able to come up with
something, it's too much to put down in a post so I'm attaching a
sample worksheet with notes.

Note: I'm assuming that your product list is in the same order all the
way down your range and there are no gaps (blank rows). Also you may
need to alter the formulas so that they pull the data from the correct
rows. In my sample worksheet the first dates are in row 4 and product
list starts in row 5.

Hope it's something you can use.

Regards
JG


+-------------------------------------------------------------------+
|Filename: month by month sales sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4181 |
+-------------------------------------------------------------------+

--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497552