Basic VBA

[Laguna11]

Hi!

I'm trying to create a simple macro that will copy the formulas that are held in c5:AA5 and paste it into the first blank row of the table (columns A & B are blank and there is no further data held after column AA).

I'd prefer the macro to be used on the active sheet as I will need to replicate this sheet for all other members of staff of my department.

Many thanks

 

[VoG]

Try

Sub test()
Range("C5:AA5").Copy
Range("C" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteFormulas
End Sub

 

[Laguna11]

Thank you very much- it's perfect!!! You have made someone very happy today!