Referencing to last cell in a coulmn

  • Thread starter Thread starter Mark H
  • Start date Start date
M

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
 
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)
 
=LOOKUP(9.99999999999999E+307,3rdWorksheet!X:X)

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