Thanks a lot Greg.

Having experimented with this I don't seem to be able to make the
calculations dynamic e.g. I need to press F9 to recalculate every time I make
a change so reluctantly I think I'm better off creating the table in Excel so
any changes are immediately recalculated. Thanks again though