my mistake. all working fine. i had missed another step in formtatting
my source data. It had blank lines in between the date fields.

i can even automatically create the pivot table now. excellent.

minor issue is that i use the date the report was created (today()) as
a comparison to wrok out the age. However i want this to be a fixed
value and not constantly compared to the 'day' the spreadsheet is
opend.

is there a way of easily doing this?
Paul


--
pamalpass
------------------------------------------------------------------------
pamalpass's Profile: http://www.excelforum.com/member.php...o&userid=31952
View this thread: http://www.excelforum.com/showthread...hreadid=516726