Automate comparison of data

$30-250 USD

已完成

已发布

超过 10 年前

$30-250 USD

货到付款

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

Data Processing

Excel

项目 ID: 5016457

关于此项目

4提案

远程项目

活跃11 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@deepbluetech

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 job. The macro will generate output file similar to "Freelancer - Sample Output". Please confirm and I can start working on it right away. Shall complete it within a day. Regards, Arul

$50 USD 在1天之内

5.0

(164条评论)

7.2

4威客以平均价$107 USD来参与此工作竞价

@expertatwork

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

$66 USD 在3天之内

4.8

(145条评论)

5.8

@thanhhungqb

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 VBA function to do it for you. Please contact me to start working. Thank you for your attention, thanhhungqb

$100 USD 在3天之内

5.0

(15条评论)

3.7

@igors233

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). It will be fast and could be used again (for future data in same format).

$210 USD 在7天之内