I have a table in which I record some daily figures. I'd like, once I
input the figures, a row to be automatically added to another worksheet
(in the same workbook) recording a calculation on those figures.

I know I could paste the formula in each cell in many rows of the
worksheet on which the calculation is to appear but I'm sure I must be
able to automate it - and if I don't automate it I'm sure I'll eventually
add more rows to the first sheet than there are rows with the formula on
the calculation sheet - and also, when there are lots of formulae in a
worksheet it can slow down recalculation.

Justin.

--
Justin C by the sea.