need to put Cell value using Vba

Hi Guru's

I have a two cells which can be updated by macro.By running Macro the first cell will be Filled out by macro (I have mentioned in the macro like cell value H12).But in the second cell i need to put 0 for all the rows.I have 1000 of rows in the consolidated sheet.The first cell is filled out by macro.How i can put the oneline code or code modification for the below code.

Please Login or Register  to view this content.

Pls help me


Thanks,
Lakshmanan

Can anyone look and help me out..

Thanks

I have added sample work book and comments in the attached sheet.Pls have a look and help me out

i have provideded the code for the First post Zbor,Here i just i dont knoe..how to put the cell values after H12..I just wan tput 0 for all the rows As mentioned in the sheet..

Hi Zbor,

Anything needed from my end?

This is the sheet which having a Macro..Pls check now and help me

No Zbor,

Actually we are consolidating all the months data from some other workbooks.Even the first cell mentioned "NA" Value also receving while macro running.So while running macro the The X1 cell of the evermonth values and X2 cell month values need to update parallely.So Is there any code change may impact the values to Zero.
Like I have tried the code like below but it is not working.Pls correct me..

Please Login or Register  to view this content.