Auto Numbering

[omdkhaleel]

I would like to have a macro by which serial no column will be numbered whenever name columns entered with value. Could anyone help to write a macro for the same? I have attached sample file to work out.

[mdmackillop]

Simpler with a formula in A5 and copy down.
=IF(B5<>"",COUNTA(B$5:B5),"")