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

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

Project ID: #5561630

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


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
(514 Reviews)

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
(254 Reviews)

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
(330 Reviews)

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
(228 Reviews)

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
(85 Reviews)

Hey There, Thanks for posting the project. Its looks very much feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirements to be on the same page and I can start to get More

$14 USD / hour
(140 Reviews)

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
(91 Reviews)

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: [login to view URL] Estate (video demonstration) [login to view URL] (video demonstrat More

$10 USD / hour
(121 Reviews)

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

$26 USD / hour
(49 Reviews)

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
(117 Reviews)

Good day, I am Excel developer of 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
(68 Reviews)

Hi Seems 1-3 hour job. Have you single pdf's export file? Or multiple files. What is amout of job. How many stroke need I update? 1000, 10000, 1 mln?

$15 USD / hour
(44 Reviews)

Hello, I'm hard worker with great Excel skills. Also my main advantage is excellent programming in VBA. You can award me with trust. With regards, Tom

$12 USD / hour
(34 Reviews)

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
(64 Reviews)

Hello Thank you for posting this nice and short project. I have downloaded and seen your file. What I understand is that a search has to be carried out in the BHE2 File, based on the account number from the Expor More

$12 USD / hour
(33 Reviews)

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, On my business we More

$15 USD / hour
(16 Reviews)

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
(17 Reviews)

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [login to view URL] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$12 USD / hour
(28 Reviews)

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

$10 USD / hour
(30 Reviews)

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
(25 Reviews)