Matching Rows with Multiple Columns in Two Worksheets

B

banjoistic

I have two Excel worksheets, each with about 1000 rows, with columns
through L (name, address, birthdate, etc.). Both sheets are formatte
the same. I need to find the rows in sheet1 that are identical to thos
in sheet2, and put those matching rows in a third worksheet. Doe
someone have a macro that can do this?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Matching data in columns 1
Macro for comparing columns and highlighting matching/differences 13
Linking worksheets, rearranging rows. 1
Compare identifier columns from 2 sheets - remove rows that are dups 2
Scrubbing two excel worksheets, returning unique values from one sheet 0
Development combinations with exclusion of columns 0
Deleting blank rows with formulas in them 7

Top