| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Matching Rows with Multiple Columns in Two Worksheets
I have two Excel worksheets, each with about 1000 rows, with columns A through L (name, address, birthdate, etc.). Both sheets are formatted the same. I need to find the rows in sheet1 that are identical to those in sheet2, and put those matching rows in a third worksheet. Does someone have a macro that can do this?
Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching multiple columns on different worksheets | Excel Programming | |||
| Matching across multiple worksheets | Excel Worksheet Functions | |||
| Counting rows from columns on multiple worksheets? | Excel Worksheet Functions | |||
| MATCHing through multiple worksheets | Excel Worksheet Functions | |||
| Find Matching Data in different columns of different worksheets | Excel Programming | |||
Linear Mode
