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!!
Bookmarks