Macro to put in year in column

[abjac]

Hi I need a macro to put in year in column A. 2 cells under the name of the country. And beside the months in column B.
When there is a space in the months in column B. It have to count down the year before. Again beside the months in column B.

When it comes to the next country in Coulumn A. It have to do the same for the next country.
Reason why i need a macro, is because the years count down can be variable for each country. It have to start with the present year, for every country.

I have put a test file and you can see it in sheet 2 what i want. I have added in column A for the first year, how i want it to look.

Please have a look and maybe better to understand if you see the test file.
And you can see it in sheet 2

I use excel 2003

Thanks in advance

Abjac

[AlphaFrog]

Try this.

The code tests for a new country when a cell in column A is filled and the same row in column B is empty.

Please Login or Register  to view this content.

[abjac]

Alphafrog this is a brilliant code. I just checked it in a bigger sheet with many countries and many variables. And it works all the way.
I only have a little problem now in layout.
Its the same problem the countries and rows can be variant depends on what time/month i pull out this file.
I need to delete all the numbers in column C,D,E which are outside the rows with country(A) and months .

If you see in test sheet there is some numbers there. I know i need macro for that, because the output can be variant.
So if you can help with this one also would be really great. Then i have a clean layout with all countries to work with.

For now thanks allot ur code is brilliant. Dont know if i need to start a new thread, but i suddenly realized that this is same problem.

Please have a look if you have time alphafrog, but for now thanks for this code, its great.

Sincerely

Abjac

[AlphaFrog]

So if both A and B are blank then clear the row in C:E? Is that correct?

If yes...

Please Login or Register  to view this content.

[abjac]

That was correct Aplphafrog. Its just tested on the big sheet. It works again Brilliant. Its 2 great codes. Thanks allot i hve now a clean layout, where and when i pull this out. Really great. Thanks allot

Sincerely
Abjac

[AlphaFrog]

You're welcome. Glad it works.

Note: the clear C:E bolded code only works after the years are filled in column A.

[abjac]

Ahh sorry just saw one little thing now. If there is a country name in column A i need to clear the number in that row in column c.
The other works fine, but out for each country not the first the others/next i have a number also in column c.
Can you manage this one also.

Will be great just saw it now.

Please if time have a look on this one.

Thanks

Abjac

[AlphaFrog]

The other works fine, but out for each country not the first the others/next i have a number also in column c.

Hugh?

This will clear C:E for all blanks in column B (regardless of column A).

Please Login or Register  to view this content.

Otherwise, please explain.

[abjac]

Hi Alphafrog. Just was out here. I checked it now in the big sheet and all are just perfect. Thanks allot for your effort. It works just perfect.
Have a nice evening.

Thanks

Sincely
Abjac