Closed

Excel Macro comparing 2 worksheets (target vs actual)

This project received 39 bids from talented freelancers with an average bid price of €51 EUR.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
€30 - €250 EUR
Total Bids
39
Project Description

Dear All,

i have to compare 2 Excel work sheets. Basically a fixed target list with the actual distribution list.

The target list contains 130 product-IDs (collums A to Z) and round about 100 recipients (rows 1 to 100) whereas a "1" in the product ID collum indicates which row (customer) must receive the product.

the actual distribution list contains of colum A (row 1-100) = product IDs and in B all receipians seperated by a "/". for each product.

The job is now to compare both worksheets to find errors in the distribution. Basically i need to know if worksheet A matches B. If they do not match i need the product ID of the product where recipeints do not match with worksheet A.

Deadline for this job is [url removed, login to view], GMT +1 at 18h. I will be online around 13h to hold a conference.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online