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
Project Budget€30-€250 EUR
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online