Find Row Match and Copy to Another worksheet

[roofover]

I was wondering if anyone could help me with some code to complete this task.

I have 2 worksheets "data1" and "data2" I want to search both sheets columns a - f, if any of the rows match exactly I want to copy the row to a sheet called "datamatch".

Thanks for any help.

 

[venkat1926]

try something like this

1.in in each sheet in each row concatenate all the cells in A to f and park it in G
2. combine both the sheets in one sheet (all theows A to G)for e.g. datasheet
3sort datasheet according to column G
4. the duplicated will be adjacnet.
5. use pelarsons "highlight duplicates"
referecne:
http://www.cpearson.com/excel/topic.htm
6. remove highighted rows.
7. finally delete column G

may be better solutins are available. wait for a day.