I have a spreadsheet that will contain entries in Column A but the number of
rows will vary. In Cell B1 I have a formula based on Cell A1 that I want to
copy down in Column B to the last row of the data in Column A. I then need
to change the formulae in Column B to values and delete Column A.

I need some code to do this.

Grateful for any help.

Thanks