Create some Macros in excel

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I need an expert in Visual Basic to create Macros in order to automate tasks in Excel.

We are feeding patient information via an online form provider (formstack) into a spreadsheet. We need a macro to know when a new entry has been pushed from formstack into the spreadsheet and then build a report (see ‘patient report’ in the attached spreadsheet). The macro will need to automatically take the new patient (medicare number and doctor name) and search existing sheet to see if that patient exists:

If patient does not exist macro needs to build ‘patient report’ based on data from that entry and automatically send pdf to designated email address

If patient does exist, macro needs to build ‘patient report’ based on all data for that patient and automatically send pdf to designated email address

In addition, it we need a macro to be built that can perform the above task on data that we have already collected (so build of patient report is not be triggered by new entry but performed on batch of pre-existing data).

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #18013249

About the project

54 proposals Remote project Active 5 years ago

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex More

$500 USD in 3 days
(935 Reviews)
9.4

54 freelancers are bidding on average $438 for this job

fixitconsultech

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$444 USD in 10 days
(856 Reviews)
8.5
ParisPallas

Hello! My name is Paris. I have opened your file and I've got a clear picture of what needs to be done. I'm going to write the necessary VBA code that will detect if a new entry already exists in the spreadsheet. If More

$280 USD in 2 days
(660 Reviews)
8.7
schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid More

$400 USD in 10 days
(604 Reviews)
8.5
seaanddream

Hi, my name is Selim. I read your `Create some Macros in excel` project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can cl More

$450 USD in 7 days
(352 Reviews)
8.4
TonmoyRoy111

Dear client I have previously carried out a number of projects in excel using macros. I understand the scope of work involved in the project. Kindly contact me for further details. Roy

$400 USD in 3 days
(516 Reviews)
7.8
sloker18

I am proficient with excel macro/VBA development, I can write the macro to generate pdf report based on excel record change as specified, if you are interested feel free to message me, I am available to start your proj More

$300 USD in 10 days
(181 Reviews)
7.6
zekovicm

Hi there,I am Miljan,excel macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within More

$370 USD in 3 days
(194 Reviews)
7.9
prameswara

Hello Sir Im excel VBA macro and formula Expert :) im able to build your macro for your data patient Sir please ping me if u interested with me and im able to start discuss now Thank You Sincerely Galih AP

$300 USD in 10 days
(447 Reviews)
7.7
dgled

Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout More

$500 USD in 10 days
(96 Reviews)
7.5
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$400 USD in 10 days
(136 Reviews)
7.2
periyannas

Ok Sure. I am specialised in providing Excel VBA Automation solutions. have delivered more than 60 projects in the related technology. your project is doable and apt . Thank you

$450 USD in 10 days
(192 Reviews)
7.1
polarjin2017

Hello? How are you? I have good skills in Excel macro.... So I can complete your job in time. Hope to work with you. Thank you.

$500 USD in 3 days
(104 Reviews)
6.8
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$500 USD in 10 days
(129 Reviews)
6.7
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I can develop a macro to enter new record of patient through user friendly user form with approp More

$250 USD in 5 days
(156 Reviews)
6.2
sonarkaushik

Sir, I am well versed in tvery able to create this macro hese kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to More

$250 USD in 3 days
(104 Reviews)
6.3
katiewells3

Hey guys, I am an Australian based Business Analyst with a background in Australian Privacy compliance. I would suggest rather than your current solution you investigate looking at a web dev to build you something a bi More

$250 USD in 10 days
(33 Reviews)
5.4
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff More

$250 USD in 10 days
(25 Reviews)
4.9
rfreelancer2008

Hi there - Please see my questions/comments below inline marked with [RF]. " I need an expert in Visual Basic to create Macros in order to automate tasks in Excel. [RF] - Understood. I have experience in VBA a More

$722 USD in 10 days
(48 Reviews)
4.8
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. The task would require designing the template with appropriate formulas and using that to create a patient report on the fly. For i More

$333 USD in 10 days
(27 Reviews)
4.8
luiswilliam

Hello, I read the description of your project thoroughly. I understand your requirements basically, and I have experiences of similar project. I am professional Website builder and Mobile App developer, and talented A More

$555 USD in 3 days
(7 Reviews)
4.4