Hi,

What I would like is a macro that enters a formula in H2 i.e. =G2+1 and copies down column H until it reaches the last ‘Row‘ with data in it i.e. the rows all have data in cells A through to Q.


Any assistance would be greatly appreciated

Many thanks in advance


Rob

N.B. Excel version 2003