need help comparing data in 2 separate worksheets
 

I am trying to figure out how I can compare data on 2 different worksheets.
Here is what I am trying to do...

I have Worksheet 1 (WS1)and Worksheet 2 (WS2). Each worksheet has over 5000
rows. I need to compare that data in WS1-column B and WS2-column B. If there
are any entries that match, I need the data that is in WS2-column A to be
copied and pasted into WS1-column A.

Is there an easy way to do this?

Your help is appreciated.

-Wayne

--
Message posted via http://www.officekb.com