Copy Duplicate rows

[vrmomo]

I have about 3000 rows in worksheet1 and 3500 rows in worksheet2. Is
there anyway to copy all the duplicate rows from worksheet1 &
worksheet2 to worksheet3???

 

[Max]

One non-macro way using advanced filter?

See http://tinyurl.com/v328
which outlines the methods / steps
for a similar recent query

 

[vrmomo]

Thanks Max

 

[Max]

you're welcome!