Add serial numbers according data entry

[HaroonSid]

Hello
i want to add automatically numbers( 1 to 55 ) in column A9:A10000, when i add entry from B9:B10000

e,g
i m adding data in Range(B9:B10000), add auto number from 1 to 55, when i reach B65 then start number from start 1 to 55 again

thanx

[Trebor76]

Hi haroon2015,

Do you really need a macro? You could put the following formula in cell A10...

=IF(ROW()=10,1,IF(OFFSET(A10,-1,0)=55,1,OFFSET(A10,-1,0)+1))

...and fill down as required.

Regards,

Robert

[HaroonSid]

hello Trebor76
works perfect thanx lot

will add u reputation

[Trebor76]

Thanks for the feedback and marking the thread as solved (and of course for adding to my reputation )