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

Completed Posted Aug 27, 2015 Paid on delivery
Completed Paid on delivery

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)

Data Processing Excel Microsoft Visual Basic Visual Basic for Apps

Project ID: #8351791

About the project

9 proposals Remote project Active Aug 27, 2015

Awarded to:

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 More

$35 USD in 1 day
(52 Reviews)
4.8

9 freelancers are bidding on average $86 for this job

zExcel

A proposal has not yet been provided

$110 USD in 1 day
(207 Reviews)
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 More

$100 USD in 2 days
(163 Reviews)
6.7
fhasanbd

A proposal has not yet been provided

$200 USD in 4 days
(124 Reviews)
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 in 2 days
(51 Reviews)
5.5
muzammil21

A proposal has not yet been provided

$147 USD in 3 days
(24 Reviews)
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 in 0 days
(66 Reviews)
4.9
TonmoyRoy111

A proposal has not yet been provided

$30 USD in 3 days
(27 Reviews)
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 More

$50 USD in 3 days
(12 Reviews)
3.3