I want to create a macro which will look at for example column A and find the last number entered then add a row below it and to do this every time its ran.
You can use this macro :
Dim n As Integer
n = Cells(Rows.Count, 1).End(xlUp).Row
Thanks to aquarelle
for this tip on the forum.