Create routine or program to insert date from one speadsheet to another

已完成 已发布的 Aug 27, 2015 货到付款
已完成 货到付款

I need a routine, program or batch file for the following.

open spreadsheet monthly [url removed, login to view]

column B is the part number. remove the non part number text. example "Subtotal (2 Items(s))

column H(Ext Cost) is the cost

Open spreadsheet [url removed, login to view]

Column B is the part number

Column G(New Cost) is the cost

Match the part number and cost from spreadsheet [url removed, login to view] to the part number and cost in monthly [url removed, login to view]

Insert the cost(column G) from [url removed, login to view] to the cost(Column H) in monthly [url removed, login to view] for the same part number(column B)

数据处理 Excel 微软 Visual Basic Visual Basic的应用程式

项目ID: #8351791

关于项目

9个方案 远程项目 活跃的Aug 27, 2015

授予:

cgullapalli

HI, I am good at excel and macros. Looking forward to work on this project. I could able to see only "cost" excel sheet. can u plz provide the other one. I would like to discuss before start of the project. Looking 更多

$35 USD 在1天内
(52条评论)
4.8

有9名威客正在参与此工作的竞标,均价$86/小时

zExcel

A proposal has not yet been provided

$110USD 在1天里
(207条评论)
7.3
jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among 更多

$100 USD 在2天内
(163条评论)
6.7
fhasanbd

A proposal has not yet been provided

$200 USD 在4天内
(124条评论)
6.4
P0L

Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$75 USD 在2天内
(51条评论)
5.5
muzammil21

A proposal has not yet been provided

$147 USD 在3天内
(24条评论)
5.2
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$30 USD 在0天内
(66条评论)
4.9
TonmoyRoy111

A proposal has not yet been provided

$30 USD 在3天内
(27条评论)
3.8
KAES619

Hi, I have experience in data entry .I have all the eligibility that you are looking for that particular task. I am very interested to this job, because my skill refers to the job.I can do this project very carefully 更多

$50 USD 在3天内
(12条评论)
3.3