In Progress

Automate comparison of data

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".

Skills: Data Processing, Excel

See more: vba freelancer excel, processing of data, objectives of freelancer, objective of a freelancer, freelancer sample projects, freelancer sample, freelancer projects on excel, freelancer or id, freelancer comparison, description of freelancer, data projects freelancer, excel 2013 vba, objective of freelancer, vba projects, vba project f, vba freelancer, vba e, row b, freelancer in vba, freelancer excel vba, freelancer excel projects, excel automate, automate], data processing vba, excel macro row

About the Employer:
( 2 reviews ) Petaling Jaya, Malaysia

Project ID: #5016457

Awarded to:


Hi keryeancheah, I am an Excel macro expert and have completed more than 190 projects, most of which were dealing with Excel macros. I have gone through the description as well as the files and can take on the j More

$50 USD in 1 day
(164 Reviews)

4 freelancers are bidding on average $107 for this job


Hey keryeancheah, please let us know if you are using WINDOWS... we can do this. please reply. thanks

$66 USD in 3 days
(145 Reviews)

Dear sir, I have read your requirement carefully and also have a look on 2 files attached. I am interested in your project. I have been finished one project same with your project on the last week. I will write a More

$100 USD in 3 days
(15 Reviews)

Greetings, I'm software developer with large experience in office (Excel) automation. It will produce a standalone application which load data from excel, process it in memory and save it to Excel (to same or new sheet More

$210 USD in 7 days
(3 Reviews)