Cell data equal to another in different worksheet that is always moving

[timonium75]

HI,

I need to have the data in a cell in one worksheet to automatically equal the data in another everytime the original data changes. My problem is the data I need to copy is always moving. In a check register for example, I need to copy the final amount in the register to another cell in a different worksheet but obviously the cell that contains the data is in a different cell every time I add another line to the register. How do I do that???

Thanks

[PaulM100]

Formula to find the final amount, assuming that it will always be the last cell

=LOOKUP(2,1/(A:A<>""),A:A)

[timonium75]

Thank you,

Still trying to figure out the formula. Makes a little sense. So if I had a value in the last row of column H in a worksheet and I wanted that value in another cell in a different worksheet, what would the formula look like? This is what I have and I get a parse error. =LOOKUP(2,1/(Chk Register!H:Chk Register!H<>""),Chk register!H:Chk register!H)

I need the last value in column H in a sheet named Chk Register in another sheet.

[timonium75]

Anyone have any idea why I'm getting the parse error?

[Pepe Le Mokko]

Perhaps =LOOKUP(2,1/('Chk Register'!H:H<>""),'Chk register'!H:H)

Also have a look at http://www.xldynamic.com/source/xld.LastValue.html