Thank you for the help!

"Bob Phillips" wrote:

Otto's formula will work for numbers in column A, where there are no
embedded blank cells. To cater for blanks, numbers or text, try

=LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535)

--
HTH

Bob Phillips

"Otto Moehrbach" wrote in message
...
The formula:
=OFFSET(A1,COUNT(A2:A1000),0)

in any cell will result in the value of the last occupied cell in Column
A.

Note that cell A2 must be occupied. HTH Otto

"ventimaj" wrote in message
...
I want to take the LAST cell of column A (which will be changing with
entries) and paste it into a fixed cell in column B.

Thanks