Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,
Ken
Copley