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

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

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

It's .xlsx format. There is no code inside.

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?

As I say, There is no code inside. I can not test it without a code.

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

Why don't you write 0 as default?

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.