Lengkap

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

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Paddington, Australia

ID Projek: #18013249

Dianugerahkan kepada:

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 Lagi

$500 USD dalam 3 hari
(647 Ulasan)
8.3

57 pekerja bebas membida secara purata $435 untuk pekerjaan ini

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 Lagi

$450 USD dalam 7 hari
(298 Ulasan)
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 Lagi

$400 USD dalam 10 hari
(298 Ulasan)
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 Lagi

$370 USD dalam 3 hari
(107 Ulasan)
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 dalam 10 hari
(332 Ulasan)
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 Lagi

$280 USD dalam 2 hari
(172 Ulasan)
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 Lagi

$500 USD dalam 10 hari
(64 Ulasan)
6.7
zebracaro

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

$400 USD dalam 10 hari
(115 Ulasan)
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 dalam 3 hari
(278 Ulasan)
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 dalam 3 hari
(65 Ulasan)
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 dalam 10 hari
(81 Ulasan)
5.7
$250 USD dalam 3 hari
(67 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(102 Ulasan)
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 dalam 10 hari
(64 Ulasan)
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 dalam 10 hari
(52 Ulasan)
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 Lagi

$250 USD dalam 5 hari
(77 Ulasan)
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 Lagi

$250 USD dalam 10 hari
(24 Ulasan)
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] Lagi

$300 USD dalam 5 hari
(55 Ulasan)
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 Lagi

$300 USD dalam 10 hari
(47 Ulasan)
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 Lagi

$722 USD dalam 10 hari
(47 Ulasan)
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 Lagi

$333 USD dalam 10 hari
(23 Ulasan)
4.5