Get value of last non blank cell in a column on different worksheet

[eriknokc]

I am trying to get the value of the last non blank cell in a column on different a worksheet. The example below works perfect if everything is on one worksheet, but I am needing this to work with the data being on Sheet2 and the results of the formula to appear in cell B1 of Sheet1 since the database on Sheet2 will be rather large. Does anyone anyone know how to make this work?

Example:
1 AAA
2 BBB
3 CCC
4 DDD
5 AAA
6 CCC
7 AAA
8 BBB
9 DDD
10 AAA
11 CCC
12 AAA
13 DDD
14 DDD

Enter the following formula in cell B1: =OFFSET(A1,COUNTA(A:A)-1,0)

The result: DDD

[martindwilson]

=OFFSET(Sheet2!A1,COUNTA(Sheet2!A:A)-1,0)
or better
=LOOKUP(REPT("z",255),Sheet2!A:A) will return the last cell with text in

[eriknokc]

I swear I tried that but it didn't work, now I try it by copy and pasting what you put and it works. Maybe I had something slightly off. Thanks for your assistance.