Automatic insert the last number in a list to another Excel works

[Guest]

Every month I enter current electric charges in the corresponding month's
cell. I want to take the most recent month's entry, the last entry, and
insert in a cell in another work sheet. How do I get this done automatically?

 

[Earl Kiosterud]

The only thing that could insert the value somewhere else is a macro. But a
formula in the next sheet could extract the last item in a column from a
sheet. This formula would return the last item in column I of Sheet2. The
cells in column I must be populated from the top, no empty cells, or it'll
mess up.

=OFFSET(Sheet2!I1,COUNTA(Sheet2!I:I)-1,0,1,1)