Filling cells

[ronind20]

Hi everyone, this is my first post.
I need help in filling around 6000 cells in excel. The scenario is as follows:

Consider in column A, starting from the 1st cell I fill in the value 12 till the 5th cell. Then I start with 13, again filling it 5 times, so on. How do I do this for all 6000 rows.

12
12
12
12
12
13
13
13
13
13
.
.
.

Kindly help.

Ronald S

[tom1977]

Hi
try this code

Please Login or Register  to view this content.

or wait for other answer with formula or other trick (but now it could be long