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?
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?