returning last value in range 1

[sedgely]

i have a column of values in excel that gets populated monthly i.e. this months figure is added to the last cell in the column.
What i want to do is look at the column and return the last entry into another sheet. therefore the new sheet will always show the value of the last cell in the column regardless of how many entries are made.
Does any kind soul out there know how to achieve this?

Thanx
Craig

 

[xlbo]

Say the data is in column G
In the new sheet, enter
=Indirect("Sheet1!G" & countA(sheet1!G:G))

wher ethe data is on sheet1

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[sedgely]

Thanx Geoff
That was perfect

Craig