Completed

Automate comparison of data

This project was successfully completed by deepbluetech for $50 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30-$250 USD
Completed In
1 day
Total Bids
5
Project Description

I have an MS Excel file with 6 columns of data. The data in columns A and B are the material ID and material description respectively of project A, the data in column C and D are the material ID and material description respectively of project B while the data in column E and F are the material ID and material description respectively of project C. The objective of this assignment is to:
(a) put material ID which are common to 2 or more projects on the same row
(b) the rows corresponding to material ID which a project does not have but another project(s) has will be left blank
(c) all material ID runs in sequential order

It would be preferred if you are able to use VBA macro to automate the output of this assignment as the output is needed within a short time.

The MS Excel file with the 6 columns of data which you need to work on in order to deliver the objectives of this assignment (a) - (c) as above is the attached file named "Freelancer - Material ID and Material Description". A sample of the expected output of this assignment is in the attached file named "Freelancer - Sample Output".

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