A programme to compare two excel spreadsheets and highlight specific differences
- or -
Post a project like this$$$
- Posted:
- Proposals: 24
- Remote
- #1169190
- Expired
Excel Programmer, VBA, VB and VB.net programming, Desktop Aplications,Outlook Programming, Microsoft Project, MS Office Integration and automation
Lahore
3527609172391278104126831612568361237383120149111896971177608114452910507121002131
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.
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.
Helen M.
100% (3)Projects Completed
3
Freelancers worked with
1
Projects awarded
75%
Last project
29 Jun 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
Is the project still opened to submit proposal?
Tks
Sergio
18101
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies