I have two worksheets in a spreadsheet with similar values in Sheet 1 Column
A and Sheet 2 Column A. I would like to create macro that would match like
values in column A in both sheets and copy the entire row in Sheet B to Sheet
A.

I have provided an example below:

Befo

Sheet 1

A B C D E
250 mE 1
300 YOU 2
360 ME 3

Sheet 2

A B C
250 Good 2905
300 Bad 1605
360 Good 5000


After

Sheet 1

A B C D E F
250 Me 1 250 Good 2905
300 You 2 300 Bad 1605

Many thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1