Thank you for the help!

"Otto Moehrbach" wrote:

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