| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two worksheets - macro help
I am trying to compare two columns in two different worksheets. If the cell
in column model and serial worksheet #2 matches the cell in column Model and serial worksheet #1, then I want to pull data from column A, B, C, and D from worksheet #1 into a separate sheet. Help please. Worksheet #1 A B C D Model Serial 801 Beaumont 7194629 E32696R36 C2405 PSPSV05008 805 Houston 7764192 E-062306CRR TM233XC LXT21051803284 801 Beaumont 7618786 E32215R24 TM243XC LXT3005347347 Worksheet #2 Model # Serial # 32HL67 AM339004740 32HL67U AM379011491 32HL67U AM37010883 32HL67U AM37021155 32HL67U AM37011550 32HL67U AM379011448 32LC7D 708MXTC4Y105 32LC7D 706MCMT0M499 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to compare 2 worksheets... | Excel Discussion (Misc queries) | |||
| compare worksheets | Excel Discussion (Misc queries) | |||
| compare worksheets | New Users to Excel | |||
| Excel VBA Macro to compare 2 worksheets for same values | Excel Worksheet Functions | |||
| Macro to Compare Two Worksheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
