Thanks for the reply but it doesn't quite manage what i need, at the end
of each row is a formula for a sub total subtracting one cell from
another then adding the amount from a previous cell, the way the list
creation works does not allow you to modify formulas.
Any other ideas?
regards,
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=551964