Limit the Number of rows when dragging a formular

[Qamarjulius]

Hi Mr excel,
Is a way i can limit my rows in column A such that everytime i double click to drag it only goes up to 05 at a time.

A	B
H100	Jan-11
H101	Jan-11
H102	Jan-11
H103	Jan-11
H104	Jan-11
H105	Jan-11
H200	Feb-11
H201	Feb-11
H202	Feb-11
H203	Feb-11
H204	Feb-11
H205	Feb-11
H300	Mar-11
H301	Mar-11
H302	Mar-11
H303	Mar-11
H304	Mar-11
H305	Mar-11
H400	Apr-11
H401	Apr-11
H402	Apr-11

<colgroup><col style="width: 48pt;" span="2" width="64"> <tbody>
</tbody>

 

[Special-K99]

This should work

="H"&INT((ROWS($1:1)-1)/6)+100+MOD((ROWS($1:1)-1),5)

UPDATE: But it doesn't Still working on this...

 

[Special-K99]

...so try this one instead

="H"&INT((ROWS($1:1)-1)/5)*100+100+MOD((ROWS($1:1)-1),5)

 

[Chris Mack]

="H"&INT((ROWS($1:1)-1)/6)*100+100+MOD((ROWS($1:1)-1),6)

 

[Qamarjulius]

="H"&INT((ROWS($1:1)-1)/6)*100+100+MOD((ROWS($1:1)-1),6)

[wow!, this is great!]
[it works upto H905, after that i need it to replace 10 with O for October, then 11 with N for November and 12 with D for December]

[ see, the code H102 for instace, is a lot No, where H represents the year of manufacture, 1 represents Jan and 02 represents the second batch to be produced. The lot No cannot accomodate 6 digits(at least in this case) hence the need to replace 10,11 and 12 with one digit letters.]
[thanks for the good work so far]