software

HOW DO I TAKE DATA FROM ONE SHEET AND COMPARE IT WITH DATA FROM ANOTHER SHEET
AND IDENTIFY AND SORT OUT OR ISOLATE DATA THAT IS FOUND IN ONE SHEET BUT NOT
THE OTHER. MOST OF THE DATA IN THE TWO SHEETS WOULD BE IDENTICAL BUT THERE
WILL BE SOME NEW ENTRYS ON THE
OTHER SHEET THAT I WANT TO IDENTIFY.

For arguments sake, suppose your sheets are MasterSheet and TestSheet, with
the key value that uniquely identifies records in column A of each sheet,
starting in row 2. In the first blank column of the TestSheet (where we'll
check for additions), enter the formula =match(a2,MasterSheet!A:A,false).
The result will be either a number (indicating the matching row from the
MasterSheet) or #N/A indicating no match. Copy that formula down as many
rows as necessary. Then select the column and Data gt; Filter gt; Autofilter and
select #N/A. The rows shown are additions, not yet on the MasterSheet.

quot;STEVE THE PARTS GUYquot; wrote:

gt; HOW DO I TAKE DATA FROM ONE SHEET AND COMPARE IT WITH DATA FROM ANOTHER SHEET
gt; AND IDENTIFY AND SORT OUT OR ISOLATE DATA THAT IS FOUND IN ONE SHEET BUT NOT
gt; THE OTHER. MOST OF THE DATA IN THE TWO SHEETS WOULD BE IDENTICAL BUT THERE
gt; WILL BE SOME NEW ENTRYS ON THE
gt; OTHER SHEET THAT I WANT TO IDENTIFY.