Excel automation

Closed Posted 2 months ago Paid on delivery
Closed Paid on delivery

NEED THREE SHEETS

Patient Entry Sheet

Columns:

Patient Name

Phone Number

Last Visit Date

Follow-Up Interval (in days/weeks)

Next Appointment Date (automatically calculated)

Description/Notes (for treatment notes or other relevant information)

Purpose: To enter and store patient details, calculate their next appointment date, and record any notes or treatment descriptions.

Today's Call List Sheet

Columns:

Patient Name

Phone Number

Next Appointment Date

Call Status (checkbox or dropdown for 'Called', 'Not Called', etc.)

Description/Notes (pulled from the Patient Entry Sheet)

Purpose: To display patients who need to be called today, along with relevant notes.

Additional Requirement: If the Call Status is not marked as 'Called', the patient should remain on the list for the next day.

Complete Patient List Sheet

Columns: A comprehensive list of all patient details, including notes.

Purpose: To maintain a complete record of all patients, their appointment history, and any notes or treatment descriptions.

Functional Requirements

Automated Date Calculation: The system should automatically calculate the Next Appointment Date based on the Last Visit Date and Follow-Up Interval.

PLEASE ALSO SUGGEST SOME OTHER TOOLS TO MAKE THIS EASY

Excel Visual Basic Software Architecture PHP Data Entry

Project ID: #37489908

About the project

33 proposals Remote project Active 1 mo ago

33 freelancers are bidding on average ₹1606 for this job

ravinderkumar248

Hi there, I can help you with your Excel VBA automation project based on your requirements. I am a proficient expert with 10 years of experience in Excel VBA, MS Access, Power BI, and Tableau. My expertise encompass More

₹2000 INR in 2 days
(162 Reviews)
6.1
paulodayto08

Hello, I can create you an automated tool using Excel and VBA Macro with Dynamic Dashboard. My name is Paulo and I am a VBA Macro Developer and PMO Analyst worked in Accenture. I understand that you are looking for som More

₹1500 INR in 3 days
(84 Reviews)
5.6
mhgroup21

Dear Client, I have sound knowledge of excel and analytics. Also, I previously carried out several projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my port More

₹2500 INR in 1 day
(45 Reviews)
5.2
excelthamizha

Hi there! My name is Kamal a VERIFIED FREELANCER ✅, and I am a professional with 9 years of experience in Microsoft Excel and VBA/Macro programming. During my career, I have had the pleasure of working with many differ More

₹1050 INR in 1 day
(3 Reviews)
1.9
Asadjutt111

Hello! My name is Asad, and I am a dedicated data maestro with over a decade of freelancing experience. I specialize in data analysis, making me your go-to expert for unraveling the hidden stories within the numbers. I More

₹1050 INR in 2 days
(2 Reviews)
1.7
kumawatshekhar71

Hi, This can be implemented with Sharepoint Form, PowerApp App and Power Automate with one 0ffice 365 license. There becomes an entire system including other benefits such as teams and Office 365 features. I have r More

₹5000 INR in 10 days
(3 Reviews)
1.6
mehakaftab1

Hi, I am highly experienced in data entry tasks and have a keen eye for accuracy and detail. I can efficiently input and organize your data, ensuring a high level of quality and timely delivery. Let's work together to More

₹1050 INR in 1 day
(3 Reviews)
1.2
shiva39120

Im working as analyst in one multinational company in my free time i will working on these kind data works before also i had got project like this. As i have experience in scheduling, forecasting, employee data managem More

₹1050 INR in 2 days
(1 Review)
0.7
aryanvavale2605

Hi, I am highly experienced in data entry tasks and have a keen eye for accuracy and detail. I can efficiently input and organize your data, ensuring a high level of quality and timely delivery. Let's work together to More

₹1050 INR in 1 day
(0 Reviews)
0.0
aadiiiroy94

Thanks for considering me for this project. I am excited to learn more about what you're looking for with your attendance sheet and help create an editable format that can accommodate up to 50 people. I have 2 years o More

₹1050 INR in 3 days
(0 Reviews)
0.0
palwashatofiq

Im very good in processing and managing any type of data easily and within secondz . And i think I'm perfect for this job so you must have to hire me

₹1050 INR in 7 days
(0 Reviews)
0.0
Haripriyavarma

I came across your intriguing job posting for active and enthusiastic freelancers, and I am thrilled at the opportunity to contribute to your exciting project. As a newcomer to the freelance scene, I bring fresh perspe More

₹1050 INR in 7 days
(0 Reviews)
0.0
Usmanuddinexpert

These tasks are all relatively straightforward and can be completed by freelancers with basic data entry skills. The estimated time for each task is based on the average time it takes to complete the task manually. How More

₹1250 INR in 6 days
(0 Reviews)
0.0
caddoctor247

Hello, I am Yernaidu, a full-time freelancer with 8+ years of experience. I specialize in providing reliable, responsible and excellent quality services at a reasonable price. I understand you need three sheets to en More

₹1500 INR in 2 days
(0 Reviews)
0.0
guddytiyasha

It can be hard to stand out from the crowd, but follow these tips to Write an attention grabbing bid

₹1050 INR in 7 days
(0 Reviews)
0.0
mosaqibsiddiqui

Dear Sir / Madam , I hope this message finds you well. I am writing to express my interest in your project as you posted on freelancer. With my experience and skills, I am confident in my ability to deliver high-qual More

₹1050 INR in 7 days
(0 Reviews)
0.0
forambhavsar18

I am the best candidate for this project because I have experience to finish the project on time with expected results.

₹1050 INR in 7 days
(0 Reviews)
0.0
adityasinghghosh

Hey sir my name is Aditya I will do your work very few time I have been experience in many field it so I will do your work

₹1000 INR in 1 day
(0 Reviews)
0.0
robinh2881

hi sir, I am a highly experienced data entry operator since i am working in various govt departments for a long time. i have a keen eyes on accuracy and timely delivery of task. i would be very grateful to work for yo More

₹1050 INR in 7 days
(0 Reviews)
0.0
WasimSharief

Hi, i am an expert in Excel. Excellent Knowledge in formulae. Don't just wait, share me the details about job. I assure you that your job will be completed in time in with clear and nice format.

₹950 INR in 7 days
(0 Reviews)
0.0