need help comparing data in 2 separate worksheets

  • Thread starter \Wayne via OfficeKB.com\
  • Start date
W

\Wayne via OfficeKB.com\

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking worksheet and multiple cells 1
Compare two different workbook sheet to show the difference in text 0
Find last cell in a column, Delete its contents and make it active 5
Compare data on 2 separate worksheets. 3
Sum.If function but depending on 3 different columns? 7
Retrieving a field from another worksheet - with conditions... 3
formula to add year to date figures 0
Matching content of one worsheet against another 4

Top