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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two worksheets - macro help
could someone please HELP??? I've tried to do a match and vlookup with no
luck.. "pm" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two worksheets - macro help
On 30 Jan, 02:29, pm wrote:
could someone pleaseHELP??? *I've tried to do a match and vlookup with no luck.. "pm" wrote: 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. *Helpplease. * 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 * * * *- Hide quoted text - - Show quoted text - Hi, You need to add a column to each worksheet that shows a single string of the model and serial number. e.g. If model is in column A and serial is in column B the formula in your new column on row 2 would be: =A2&B2 This would give one long value for model and serial e.g. 32HL67AM339004740 Once you've got a column like this in each worksheet you can sort in this order and then do a VLOOKUP on these values in a new sheet. If you need further help - please feel free to email me the spreadsheet and I'll do it for you. Jason http://www.justgiving.com/goodsamaritanit |
Reply |
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) |