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