|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 3rd 12, 02:56 PM
|
|||
|
|||
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. 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| matching multiple columns on different worksheets | Bob | Excel Programming | 1 | May 19th 08 06:25 PM |
| Matching across multiple worksheets | Pete | Excel Worksheet Functions | 2 | February 9th 08 06:58 PM |
| Counting rows from columns on multiple worksheets? | The BriGuy[_2_] | Excel Worksheet Functions | 2 | November 10th 07 03:47 AM |
| MATCHing through multiple worksheets | [email protected] | Excel Worksheet Functions | 1 | December 27th 05 08:31 PM |
| Find Matching Data in different columns of different worksheets | No Name | Excel Programming | 0 | June 30th 04 10:02 PM |
Linear Mode
