Closed

Excel Macro

I have file [url removed, login to view] which is produced by a pdf export after the auditor collects the data. In [url removed, login to view] the field names are in column A and data contents in column B. Certain cells of information in [url removed, login to view] need to update specific cells in BHE2.xls. The row to update in [url removed, login to view] is based upon a common account number in [url removed, login to view] and that row in [url removed, login to view]

Account number in [url removed, login to view] is row 11. In [url removed, login to view] - search column B to identify that row 9 matches the account number.

Then in BHE2, update columns X and Y with data from rows 17 and 18 in Export.

Skills: Excel, Visual Basic

See more: information auditor, auditor search, auditor+, excel export pdf, excel macro row, xls visual basic, excel 2014 macro, excel column update, export excel pdf, export data excel pdf file, excel data update macro, delete specific data macro excel, excel macro data pdf, pdf excel data macro, excel update macro, macro data pdf, visual basic data pdf file, pdf export, excel xls pdf macro, excel macro export data file, macro export data excel file, macro data pdf excel, excel export macro, search macro, account number search

About the Employer:
( 0 reviews ) Saint Paul, United States

Project ID: #5561630

50 freelancers are bidding on average $16/hour for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$14 USD / hour
(182 Reviews)
6.7
seaanddream

Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 More

$8 USD / hour
(64 Reviews)
6.2
zExcel

Hi, I will be happy to help you with this project on fixed fee basis. Please feel free to message me for more info

$15 USD / hour
(55 Reviews)
5.9
maverick44000

Hi Karen. I have read the description and this job can be done in 3 to 4 hours time. Kindly discuss so we begin with the project. Regards. Usman.

$15 USD / hour
(36 Reviews)
5.8
srinichal

I am willing to discuss further about the project as I am an expert in delivering macros .

$26 USD / hour
(37 Reviews)
5.8
jaylancer43

Hello - 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 niche More

$12 USD / hour
(53 Reviews)
5.3
shikhamehta

Hey, I am an expert with Excel based solutions as you would see in my work history here on freelancer. I have been highly rated and recommended for the quality I deliver. By looking at the requirement and the spread More

$12 USD / hour
(51 Reviews)
5.2
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$10 USD / hour
(32 Reviews)
5.1
SiroosJafary

Good day, I am Excel developer of spreadshetweb.com. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatt More

$8 USD / hour
(21 Reviews)
4.7
buyaspreadsheet

Hi Karen. Why pick me? Ready to start. Able to turnaround very quickly. I have outstanding feedback without exception and I run my own Professional Excel & VBA Consultancy, www.buyaspreadsheet.com. On my business we More

$15 USD / hour
(16 Reviews)
4.7
ethicalboy

Hello Karen, ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel More

$10 USD / hour
(30 Reviews)
4.7
carivera

Hello, 6+ Years of experience working with Excel VBA (connecting to databases to transfer data), for automated reports. Very enthusiastic professional, detailed-oriented and very hard-working. Have spent the las More

$12 USD / hour
(15 Reviews)
4.6
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. During our contract I will be available via Skype/Gtalk, email and via site message center. All of th More

$15 USD / hour
(14 Reviews)
4.5
microk

Expert here.. Please check samples on my youtube channel : [url removed, login to view] Cheers! Microk xTremeExcel [url removed, login to view]

$10 USD / hour
(30 Reviews)
4.5
manishadk

Hi, I am ready with demo version of macro. But I can not send file through freelancer. I have uploaded demo version on web hosting server at below URL. Macro is added in BHE2.xlsm. http://kdineshin2009.brinkster. More

$11 USD / hour
(15 Reviews)
4.1
AndroidAll

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show my ability, I c More

$15 USD / hour
(9 Reviews)
4.0
nswapsj

Hello Karen, Just reviewed your task and happy to do this for you. Moreover I will make the whole thing look professional so you can print it out and send it to customers for example! Send me a message and we can star More

$12 USD / hour
(4 Reviews)
3.9
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat More

$10 USD / hour
(10 Reviews)
3.9
denissilanov

Hi! I have 8 years experience in programming and know Excel / VBA well. I can make this project for you. Everything will be done according to your requirements. Denis.

$12 USD / hour
(5 Reviews)
3.6
richardst

Hello, Sir. How are you I have fully read your project description and carefully inspect the 2 excel files. I think i am suitable to your project because i have so much experiences in excel macro programming. More

$11 USD / hour
(5 Reviews)
3.6