Copy data into different every month

Hi,

Newbie to VBA, so could do with some help.

"MonthData" has values populated from another excel sheet.
I have to copy data from "MonthData" sheet to "Database" for each month to create a yearly database.

Cell B1 in "MonthData" should be checked with 2nd row in "Database" sheet.

I can basically run many times in April, but it should copy only into April column.
And if i run in May, it should copy in May column in "Database".

I tried doing it with formulae, but with no success.

Thanks in advance for any help.
Anjlive

Dear Pierre,
Thanks alot for your help.. I will work on transferring budgeted data and if faced any error, will surely ask for help..

Originally Posted by p24leclerc

Look at the attached workbook or here is a macro to do that:
Do you want the budgeted data to be transfered as well?
Can you do the modification by your own?
If not, just tell us and we'll help you do it.

Extended to budgeted values.. it works wonderfully. Thanks for all the help..