I have two sheets, sheet1 contain header and data below that header.
Sheet 2 contain only header.
If sheet1 header matches sheet2 header than transfer the whole data below that header.
Example:
Sheet1:-
empid emp_name emp_add contact_no remark
111 xxx pune 211067 ok
222 yyy london 3333300 ee
333 zzz mumbai 777777 rrr
444 aaa paris 0099988 ttt
555 bbb dallas 778888 uuu

Sheet2:
empid emp_add remark

After match found then
Sheet2:
empid emp_add remark
111 pune ok
222 london ee
333 mumbai rrr
444 paris ttt
555 dallas uuu

Please hepl me out to do this.
Waiting for your replly.