Compare Excel Tables

  • Thread starter Thread starter Nicola
  • Start date Start date
N

Nicola

I would very much like to impress my boss and find out
how you compare data from two worksheets and look for
differences. For example a list of customers and
addresses on two worksheets and to ensure the data is
correct on both see which worksheet the data is missing
from. Can anyone help? Please.
 
Hi,

If the customer number/name is common in both the worksheets, use
Vlookup function.

Regards

Govind.
 
You must log in or register to reply here.

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

matching & combining data from seperate worksheets 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Compare two lists 1
How to compare worksheets so differences are identified 1
comparing two worksheets 1
Question about Comparing Data 1
Compare data in two worksheets 1
Excel Comparing two columns 1

Back
Top