Off the top of my head I'd say that if this App is spitting data out in a
database style format, then try throwing a pivot table at it and see if you
can build that report. As long as the data is date based you can group it
in a multitude of different ways. Debra Dalgleish has a gret intro to pivot
Tables at the following link, so perhaps take a couple of minutes to have a
look at that:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip