Hi

My bad english as I should of expresssed my comment better.
I appreciate 2003 has pivot tables but it has to be in 2003 and I am trying
to keep away from pivot tables as users will be printing the report and just
want to keep it simple. :(

I have adaptered Eva's suggestion to show it by buisness plan quarter and
will look to try and get the perfect solution. i.e. calculate the actual days
per month allocated so need to identify the month from a dd/mm/yy date, to
match against a mm/yy and then add the days to a total for the individual for
that month.

Many thanks anyway.

"Gord Dibben" wrote:

2003 has the Pivot Table function.


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 09:09:02 -0800, UKMAN
wrote:

hi was trying to keep away from pivot as it has to be 2003 compatable

thanks anyway

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
No code, no formulas:
http://c0718892.cdn.cloudfiles.racks...03_03_10a.xlsx

.


.