How to copy Matching columns Between Sheets from Excel VBA?
I have some columns in Sheet1 & Sheet2

Sheet1 has Values in it.

I need to copy the corresponding data from sheet 1 to sheet 2 by matching the columns from sheet1 & Sheet2

The requirement is for ex: Sheet 1 has Qty. column with values & Sheet 2 has Qty column

I need to copy the rows values from the Column " Qty " in sheet 1 to the column " Qty " in sheet 2 (i,e) by matching the Headers

Kindly suggest me some code to achieve this in Excel VBA

Thanks

Prabu M
 
How to copy Matching columns Between Sheets from Excel VBA?
===

I have some columns in Sheet1 & Sheet2

Sheet1 has Values in it.

I need to copy the corresponding data from sheet 1 to sheet 2 by matching the columns from sheet1 & Sheet2

The requirement is for ex: Sheet 1 has Qty. column with values & Sheet 2 has Qty column

I need to copy the rows values from the Column " Qty " in sheet 1 to the column " Qty " in sheet 2 (i,e) by matching the Headers

Kindly suggest me some code to achieve this in Excel VBA

Thanks

Prabu M
 