Hello,

I would like to compare two wks and copy the corresponding data. For example.

In Sheet 1 I have:

Concord 94518
Concord 94519
Concord 94520
Concord 94521
Concord 94523


In Sheet 2 I have:

Concord
Concord
Concord
Concord
Concord
Concord
Concord
Concord

The result I should get in Sheet 1:

Concord 94518
Concord 94519
Concord 94520
Concord 94521
Concord 94523
Concord 94518
Concord 94519
Concord 94520


Any Help?

Thx.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200710/1