Create some Macros in excel

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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

Vnos podatkov Obdelava podatkov Excel Visual Basic Visual Basic za aplikacije

ID projekta: #18013249

Več o projektu

54 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

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 Več

$500 USD v 3 dneh
(935 mnenj)
9.4

54 freelancerjev ponuja v povprečju za $438 na tem delu

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 v 10 dneh
(856 ocen)
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 Več

$280 USD v 2 dneh
(660 ocen)
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 Več

$400 USD v 10 dneh
(604 ocen)
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 Več

$450 USD v 7 dneh
(352 ocen)
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 v 3 dneh
(516 ocen)
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 Več

$300 USD v 10 dneh
(181 ocen)
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 Več

$370 USD v 3 dneh
(194 ocen)
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 v 10 dneh
(447 ocen)
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 Več

$500 USD v 10 dneh
(96 ocen)
7.5
zebracaro

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

$400 USD v 10 dneh
(136 ocen)
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 v 10 dneh
(192 ocen)
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 v 3 dneh
(104 ocen)
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 v 10 dneh
(129 ocen)
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 Več

$250 USD v 5 dneh
(156 ocen)
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 Več

$250 USD v 3 dneh
(104 ocen)
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 Več

$250 USD v 10 dneh
(33 ocen)
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 Več

$250 USD v 10 dneh
(25 ocen)
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 Več

$722 USD v 10 dneh
(48 ocen)
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 Več

$333 USD v 10 dneh
(27 ocen)
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 Več

$555 USD v 3 dneh
(7 ocen)
4.4