hi
sub copyformula()
Range("B1").End(xlDown).Copy
Range("B1").End(xlDown).Offset(1, 0).PasteSpecial xlPasteAll
End Sub

regards
FSt1

"Pete" wrote:

Hi - really need a macro that allows users to go to the next blank row
(column B) and copy formulas into next row - where they enter new data.
Without a macro, I can use CTRL+END...
Any advice would be greatly appreciated, thanks in advance!