Copy data from Sheet 2 to Sheet1 and paste it in alternate rows in a new sheet

[zaveedd]

Hi,

I have data in 2 sheets . sheet1 and sheet2 are the sheet names. Data is available A to M in both the sheets.

Both will have same data except 1will have positive value the other will have Negative value.

Both the sheets have row headers .want the output in a new sheet with 2nd row from sheet 1 and 2nd row from sheet 2 ,.3rd row sheet 1 ,3rd row sheet 2 etc. Find below a sample image.

Can anybody help me with the VBA code to get this accomplished?

 

[Marc L]

Hi,​

​

if the Output sheet is in the same workbook what is its name ?​

​

Without any attachment you may have to amend any solution you could receive …​

 

[zaveedd]

Hi,​

​

if the Output sheet is in the same workbook what is its name ?​

​

Without any attachment you may have to amend any solution you could receive …​

Output sheet name can be anything as long as the Data is correct. You can name it as " output" or "Merged"etc.

 

[Marc L]

​

I was meaning for an already existing worksheet in the same workbook or should be in a new workbook ?​

 

[zaveedd]

​

I was meaning for an already existing worksheet in the same workbook or should be in a new workbook ?​

Hi Marc ,

Thank you for trying to help, It can be in the same workbook.

 

[Marc L]

​

So without an attachment I must know what is the name of the existing Output worksheet …​

 

[zaveedd]

​

So without an attachment I must know what is the name of the existing Output worksheet …​

Currently i dont have that sheet ready did a copy paste manually to show the requirement. Please let me know if any other details are needed.
I am unable to attach the sample excel wb. its asking me to install XLBB.Any other way i can send the sample WB to you?

 

[Marc L]

​

As you can use any files hosting website …​

 

[zaveedd]

have uploaded it to my Gdrive, please let me know if you are able to download it.

Google Drive: Sign-in

​

As you can use any files hosting​

 

[zaveedd]

Google Drive: Sign-in