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

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

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
(514 Reviews)
8.0
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
(254 Reviews)
7.6
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
(330 Reviews)
7.6
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
(228 Reviews)
7.3
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
(85 Reviews)
6.9
avinav606lx

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)
6.4
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
(91 Reviews)
6.2
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
(121 Reviews)
6.5
srinichal

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

$26 USD / hour
(49 Reviews)
6.0
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
(117 Reviews)
6.3
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
(68 Reviews)
5.8
Vasilchenko

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)
5.2
tomislav1975

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

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

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

$12 USD / hour
(28 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.4
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
(25 Reviews)
4.6