A programme to compare two excel spreadsheets and highlight specific differences

  • Posted:
  • Proposals: 26
  • Remote
  • #1169190
  • Expired
Tejas T.
Burim R.Ashley H.Valeriy S.Nagaratna Vijay H. + 21 others have already sent a proposal.
  • 0

Description

Experience Level: Expert
General information for the business: The data is to do with orders for subscriptions
Description of requirements/functionality: I need to compare two sets of data each week and am looking for a macro (?) that will compare them and highlight differences.

Spreadsheet 1 is our master data - a list of some 4000 subscriptions to publications, so each row is an order item.
Spreadsheet 2 is updated data that we receive each week, where there may be new orders, orders that have been cancelled, or amended or have disappeared from the data.

The two sheets have some data in common, but each has columns of data that do not appear in the other sheet and will need to be ignored.

Where the sheets have columns in common, they do not appear in the same order in the two spreadsheets, nor do the columns always have the same headings.

I want a reusable macro/programme that will compare parts of the two sets of data in this way:

User Order ID as a static reference point between the two sheets.

1. Highlight on sheet 2 rows that do not appear in sheet 1
2. Highlight on sheet 1 rows that do not appear in sheet 2
3. Highlight on sheet 1 rows that have changes in sheet 2
The only columns to compare are:
Delivery start
Delivery end
Status
First name
Last name
Each of the 3 items should be highlighted differently, e.g. in a different colour
Extra notes: I have attached sample data, which contains the same columns as the complete data. I have removed personal information.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Sergio J.

    Hi,

    Is the project still opened to submit proposal?

    Tks

    Sergio