Copy datas into next row and column

Hi all,

I have a sheets with 12 months which need to be upated by using macro.In my attached Copy sheet i have entered only Jan month data alone.But i want to place the data For the whole year like 12 months.Im having macro that pulls First months data only.If i need to add balance 11 months or more than one months means what vba code i need to use.

My concerns is..Im able to get the datas for Jan month with my macro.If the Jan month data is filled in the sheet means the Macro should place the new datas into next available row and column of the same sheet of the consolidated sheet (Here i have mentioned the Copy sheet).Like wise if 2 months data alredy filled out then next if i pull the data means it should place the datas into 3rd month of the sheet..

Please advice ..


Thanks,
Lakshmanan

How would Feb sheet look like since here, in Sheet1, you already have all months. Or am I missing something?

Hi Zbor,

For all the sheets im having 12 months which i need to update the diffrent data's..Let us assume Sheet1 i need to update the productivity details of the employee across all months.In sheet2 I need to update the count of the defects across all months..For all the sheet datas am pulling from another sheet which having all the data base sheet details...I will share you the details if you need more info on this.


Thanks,
LaKshmanan

If you have more sheets (like Jan, Feb etc) then make two of them (no need for whole year) and also desired output (manualy calculated corectly).

Hi Zbor,

If you Have any questions please ask here.I will sahre you the detail description for the above.

Thanks,
Lakshmanan

Hi,

In sheet1 if C3,D3 is filled with values na..Next pulling data will go to the blank cell of the E3 and F3..If E3,F3 Is filled with datas means..While next pulling the datas will go to G3 and H3..Like wise am asking ..Same for sheet2..

Thanks,
Lakshmanan

Can anyone please hav a look and help me out for the same..

Hi AZ-XL,

Am waiting for your positive reply..Please help me on the same..

Thanks,
Lakshmanan

BUMP with No responce