Compare two worksheets - macro help

[pm]

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

 

[pm]

could someone please HELP??? I've tried to do a match and vlookup with no
luck..

 

[GoodSamaritanIT]

could someone pleaseHELP???  I've tried to do a match and vlookup with no
luck..








- 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