Completed

Create some Macros in excel

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).

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: access visual basic create report html, visual basic word excel, web data extraction visual basic code excel, how to create a macro in excel 2010, how to create a macro in excel 2013, macros in excel for beginners, excel macro examples, use of macros in excel, how to create a macro in excel 2016, macro excel tutorial, what is a macro in excel, visual basic replace excel, visual basic solidworks excel, visual basic applications excel sorting data, visual basic scripts excel copy data cells, visual basic autocad excel, visual basic update excel data, visual basic diff excel files, visual basic using excel create forms, visual basic create excel output

About the Employer:
( 0 reviews ) Paddington, Australia

Project ID: #18013249

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
(647 Reviews)
8.3

57 freelancers are bidding on average $435 for this job

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
(298 Reviews)
7.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
(298 Reviews)
7.7
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
(107 Reviews)
7.0
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
(332 Reviews)
7.0
paris2785

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
(172 Reviews)
6.9
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
(64 Reviews)
6.7
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
(115 Reviews)
6.6
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
(278 Reviews)
6.5
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
(65 Reviews)
6.3
asadkhan3533

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
(81 Reviews)
5.7
$250 USD in 3 days
(67 Reviews)
5.8
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
(102 Reviews)
6.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
(64 Reviews)
5.6
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
(52 Reviews)
5.5
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
(77 Reviews)
5.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
(24 Reviews)
4.9
aubrey03

I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] More

$300 USD in 5 days
(55 Reviews)
5.1
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
(47 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
(47 Reviews)
4.7
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
(23 Reviews)
4.5