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

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

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