Comparing 2 lists - macro

  • Thread starter Thread starter Scotchie
  • Start date Start date
S

Scotchie

Hi again

Had a search around and cannot quite find the right answer.

I have 2 large data tables picking up data from difference sources.

Worksheet "DataA" contains the master list in column A and will
contain all data
Worksheet "DataB" contains a manual source of data in column B (so
could differ differ from DataA"

I want to compare the two data sources and if there is anything in
DataA that isn't in DataB, create a list in a the Worksheet "Errors".

Anyone help??
 
Hi
a solution without macros could be the following:
- add a helper column in worksheet DataB(column C)
- enter the following formula in C1
=IF(COUNTIF('dataA'!$A:$A,B1)=0,"X,""))
copy down
- filter dataB for this column C (all entries with an 'X' are not on
sheet DataA. You may copy this filtered list to your error worksheet
 
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

Copy row info but not in normal column sequence 6
Copying Data between Spreadsheets based on a rows value 1
how to sort data? 6
Variable value attached to data on form 1
Macro or Look-up? 1
copy cell B19:J19 Range data’s from sheet1, and to past in sheet2 4
2 Y Axes: Lines and a Stacked Column 1
Help needed with Macro designed to compare data... 2

Back
Top