Copy paste in excel sheet with macro based on matching column

143mannu Posts 1 Registration date Tuesday November 17, 2015 Status Member Last seen November 17, 2015 - Nov 17, 2015 at 02:40 AM

i have two sheets.
sheet1 and sheet2, i want copy data from sheet1 in to sheet2 based on one matching column.i have one column called index which is available in both sheet, so when column(index) match then i want to copy data of column value in to another column of sheet2. anyone can give me code for this.