Header Value matches, trasnfer the data to other sheet.

[ashish4422]

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.

[shg]

Welcome to the forum.

Maybe like this:

Please Login or Register  to view this content.

[ashish4422]

Thanks a lot!!!
i have one more question, if i have to add som constant value to a particular cells in sheet2:
Example
Sheet2:

empid emp_add group_id remark
111 pune 1 ok
222 london 1 ee
333 mumbai 1 rrr
444 paris 1 ttt
555 dallas 1 uuu

this group_id coloumn is not present in sheet1 while it is present in sheet2
and explictly i have add some constant value to this.