Referencing to last cell in a coulmn

[Mark H]

I have three (3) worksheets in a workbook. The 3rd worksheet is like
checkbook with a balance running down one column that is constantl
having numbers added to it, the bottom number being the balance like
checkbook and so on. I want to be able to reference to the last cell i
the balance column to the 1st worksheet in say cell A1 so I can see th
balance on the first worksheet. Sorry if this has been asked before

 

[Frank Kabel]

Hi
try the following in A1 if you don't have blank rows in your balance
column
=OFFSET('sheet3'!$A$1,COUNTA('sheet3'!$A:$A)-1)

 

[Mark H]

It says I've entered too few arguments

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,3rdWorksheet!X:X)

X stands for the secret balance column in the 3rd worksheet.

 

[Frank Kabel]

Hi
make this
=OFFSET('sheet3'!$A$1,COUNTA('sheet3'!$A:$A)-1,0)

 

[Mark H]

Thanks, works great