C
Chris Bezant
Hello Learned People
Can anyone tell me if there is a way of entering a
formula in a cell that will display the latest value from
that column?
I have a column containing a running total of a bank
account, say, and I want to pass that latest total to
another sheet. The problem is that the latest value is in
a different cell each time I add a new row with the next
transaction. I thought the best way to do that would be
to have a cell at the bottom of the column which picked
up the value from the last cell above it that contains a
value. Another sheet can then reference that cell at the
bottom of the column. Hope that makes sense.
Thanks for any help
Chris Bezant
Can anyone tell me if there is a way of entering a
formula in a cell that will display the latest value from
that column?
I have a column containing a running total of a bank
account, say, and I want to pass that latest total to
another sheet. The problem is that the latest value is in
a different cell each time I add a new row with the next
transaction. I thought the best way to do that would be
to have a cell at the bottom of the column which picked
up the value from the last cell above it that contains a
value. Another sheet can then reference that cell at the
bottom of the column. Hope that makes sense.
Thanks for any help
Chris Bezant