formula link to the last row of data

[Peterso]

I have these data in Sheet 1: Column A being transaction date, Column B being transaction amount
In Sheet 1 data is adding on daily basis. I want to set a formula in Sheet 2 cell A1 equal so the last row of Column B (last transaction amount) in sheets 2. How to do that without using macro? Thanks

 

[MARK858]

What do you want in Sheet2 A1, the value of last cell in column B of Sheet1 or the row number?

 

[Peterso]

I want the value (ie transaction amount) not the row number

 

[MARK858]

As it is a number try....

=LOOKUP(9.99999999999999E+307,Sheet1!B:B)

 

[Kerryx]

=CELL("contents",INDEX(Sheet1!B:B,COUNTA(Sheet1!B:B)))

 

[Peterso]

yes, that's what I want. Thanks

 

[MARK858]

yes, that's what I want. Thanks

Not sure which post you are referring to but happy you have it working.
Happy we could help