"while" loop using VBA on excel 2007

Hi,
I don't know VBA at all. But i do know that it can be used to solve my problem, I'll be glad if someone can show me what i should do.
I took this data from my excel (the months are on the same column to the right of the number, it got distorted when i copied it):

212121 January
February
March
April
May
June
313131 January
February
March
April
May
June

what i need to accomplish is copying the number 212121 to each of the cells below it, until it reaches the numer 313131. Then, do the same thing with the number 313131 and the cells below it.
The latest month doesn't have to be June, its just like that for this example. The requiered result would be:

212121January
212121February
212121March
212121April
212121May
212121June
313131January
313131February
313131March
313131April
313131May
313131June

by the way, can anyone recommend a the fastest, easiest way to learn VBA?
Thanks!!

Hi

you don't need VBA to do this - it can be done quite quickly with formulas.

Do you specifically want a VBA solution, or will formulas suffice?

rylo

Hi!
Any solution is good, its just that the data sample i copied to the post, is very short. the actual data is very very long, so i thought some VBA is in order.
but aythung goes.

Thanks

Hi

If your data is in the range A1:B12, then select the range A2:A12, Select the home tab, Find and Select, Go To Special, Blanks, OK, =a1, ctrl enter. If you only want value results, then select column A, copy, pastespecial values.

HTH

rylo

wow.
super elegant, thanks!