Thanks for the message, but I would really like it to be a bit mor
automated than that, and the enduser should be able to select from
list of available areas / names etc and then have the code run th
calculations for them rather than play with pivot tables.

If worst comes to worst, i will have to use pivot tables as I thin
this particular query has stumped everyone.

Thanks

Scott

--
Message posted from http://www.ExcelForum.com