Excel Specialist / Process Automation (Excel + preferably programming)

Budget: 10000 UAH Deadline: 10 days

I will optimize your Excel file for operators: I will set up data transfer between files and tabs, selection logic via button/checkbox, related tables for doctors, addresses, phone numbers, emails, and automation through VBA / Power Query if needed.

Does the current file already have a unique patient ID or another control to ensure that after the transfer, rows do not get misaligned and one patient's data does not end up in another doctor's card or on another tab?

Budget and deadlines will be discussed in personal correspondence after reviewing the files, the current workflow of the operators, and an example of the transfer.

Budget: 10000 UAH Deadline: 5 days

Hello, I have experience in automating Excel processes through VBA/macros and Power Query, implementing the logic for automatic data transfer between files, building linked tables with minimal manual duplication, and creating a user-friendly interface for operators (checkboxes, buttons, validation). Therefore, your task is clear to me, and I am ready to complete it. The deadline is 5 days, and the cost is 10,000 UAH. I hope for cooperation!

Budget: 4000 UAH Deadline: 5 days

Hello. I understand the task: there is a main Excel file where the operator enters patient data, and we need to automate the transfer of this data to another file and between tabs, allowing the operator to choose whether to transfer each time, plus build a convenient table structure where one doctor can have multiple addresses, phone numbers, emails, and locations, without manual duplication and with room for scaling.

I would do this in two layers. The first is a neat data structure within Excel: separate directories for doctors, addresses, contacts, and connections between them through keys, so that the same person is not duplicated, and new addresses or phone numbers are added in one place. The second is the automation of the transfer: a button or checkbox for the operator, logic for sequentially moving to the next tab or automatically pulling the next patient from the list if the operator decides not to transfer further.

This can be implemented either in VBA with macros and buttons directly in the file, or, if the volumes are growing, moving the logic to Python with openpyxl or pandas, which handles data between files according to the same scenario. I would connect Power Query for related tables and data updates between tabs. Which option is better depends on where the files are located and how many operators are working simultaneously.

I have been automating routine processes in Python and working with tables for a long time. Please clarify: are the files stored locally with the operators or in a shared location, such as OneDrive, a network folder, or a server, and how many people are entering data simultaneously? This determines whether to keep the logic in VBA inside the file or to move it to a separate script. I am ready to start with the table schema and transfer scenario.

Budget: 4000 UAH Deadline: 5 days

Good day!

I have experience working with Excel, VBA, and business process automation. I can implement automatic data transfer between files, set up the logic of tabs, structure tables, and minimize manual work for operators.

For an accurate assessment of timelines and costs, I would like to familiarize myself with the current files and requirements in more detail.

Budget: 5555 UAH Deadline: 5 days

Hello! I have been working with formulas since 2008 and with VBA-Excel (macros) since 2011. My priorities are optimizing calculations and user convenience.

A partial list of completed projects is provided in the portfolio. The timeline and cost will be discussed after a detailed review of the data transfer examples.

Feel free to write, we will discuss and create a convenient and fast program together.

Budget: 5000 UAH Deadline: 1 day

Good day. I am ready to complete this project as I have extensive experience in app development.

Budget: 4000 UAH Deadline: 3 days

Hello! The task is completely clear. I suggest using Python for implementation. It is much more stable than the old VBA, which often crashes with errors if the files are in different folders.
Here’s how we will proceed:
1. We will link the data ("one doctor - many addresses and phone numbers") so that the operator selects the doctor, and all contacts are automatically pulled in.
2. We will create convenient and understandable buttons/checkboxes for moving patients forward or stopping the process according to your logic.
3. We will set everything up so that the system suggests the next step and minimizes human errors.
I have experience in automating large spreadsheets, transferring data, and creating user-friendly workflow scripts.
Send me a sample table in private messages — we will sort out the details, and I will start working on it right away!

Budget: 3999 UAH Deadline: 5 days

Good day!
I have experience with table automation — I have worked with Apps Script (Google Sheets), building logic for data transfer between files, structuring tables for operators.
https://freelancehunt.com/showcase/work/avtomatizatsiya-sinhronizatsii-sklada-keycrm-google/2024697.html
The task is clear. I will implement it for Excel using VBA — the logic is similar to Apps Script, with buttons/checkboxes for the operator, data transfer between files, and sequential logic for selecting the next patient. I will structure the tables considering scalability — one doctor with many addresses/contacts/locations without duplication.
The timeline and cost depend on the current state of the file — I am ready to take a look and provide exact figures.
Can you share the file?

Budget: 4000 UAH Deadline: 2 days

Good day!

Automation of Excel processes is our specialized area, and the task is clear. We will optimize the file and build a convenient structure for operators to ensure stable operation without errors.

What we will do:

- Automatic data transfer between files with operator control (checkbox / "transfer or not" button) — via VBA.
- Sequential logic across tabs: transferred → choice "next to the next tab or stop"; if stop — the system automatically takes the next patient from the list of the first file and transfers them to the second tab.
- Relational data structure: one doctor → several addresses / phone numbers / emails / locations. We will normalize the tables and link them through Power Query to eliminate manual duplication and allow for scaling.
- An understandable interface with buttons, minimal manual work, and error protection.
- Tools: VBA/Macros (buttons, transfer, workflow logic), Power Query (related data and updates), and if necessary, Power Automate / Python for heavier automation.

We constantly work on similar table automation tasks. We will provide approximate timelines and costs after reviewing the current file — the scope depends on its structure.

We will discuss project details in private! Expand

Budget: 4000 UAH Deadline: 4 days

I work as a market research analyst, and my responsibilities include developing and automating sales reporting, inventory control, and accounts receivable. I have experience with macros for automating manual tasks. It can be done in Excel with access to a shared drive or implemented through Google Sheets.

Budget: 7000 UAH Deadline: 30 days

Excel can be automated with the help of the Borland Delphi programming language.

Or Excel can be completely replaced by Borland Delphi; Python can also be used if needed.

Budget: 5000 UAH Deadline: 5 days

Hello! I read your task — it's a typical story when Excel starts to "grow" and becomes inconvenient to work with. I have good experience in automating such processes, so I'm ready to help with this. What exactly I will do: I will organize the data: I will build a proper structure for the tables to avoid duplication (of doctors, locations, etc.). This will allow the system to scale properly. I will set up automation: Instead of manual copying, I will create convenient macros or buttons that will automatically transfer data where needed. This is more reliable than formulas, which often break. I will protect against errors: I will make it so that the operator cannot accidentally delete a formula or break something — the interface will be as simple and clear as possible. Regarding price and deadlines: usually, such a task takes 5-7 days and costs about 5,000 – 10,000 UAH. I would be happy to take a look at your file to say more precisely how to organize everything better. Write to me, and we will discuss the details!

Budget: 5000 UAH Deadline: 5 days

Hello, I am ready to implement the task. Let's discuss the details in private messages and show me the document that needs to be worked on.

Budget: 3750 UAH Deadline: 14 days

Good day!

I have implemented similar atypical projects where Google Sheets effectively served as a CRM system. This approach is convenient because the system can be fully adapted to your business processes, gradually expanding functionality and avoiding costs for additional software.

I recommend implementing the project based on Google Sheets. Data entry can be made as simple as possible for the user: when the "Add" button is pressed, a form will open where values can be selected from lists, necessary checkmarks can be set, data can be entered manually, and further processing of the information can be determined. After confirmation, all data will automatically be recorded in the corresponding tables and, if necessary, transferred between tabs.

All logic will be built through Google Apps Script, which will allow for maximum automation of work and minimize manual data entry and avoid errors.

The implementation timeline for the final result, considering revisions, is up to 14 days. The cost is 3750 UAH.

Budget: 5000 UAH Deadline: 5 days

Good day! I have experience in implementing similar projects and can demonstrate it. I understand how your project should be structured, we can discuss it. Write to me, let's communicate, I have many questions.

Budget: 5000 UAH Deadline: 3 days

Hello, Anastasia!

I paid special attention to the logic of the sequential movement of patients between tabs and files. For such scenarios, it is important to correctly define the statuses of records and the order of their processing to avoid data duplication or situations where the same patient is processed again.
We also noted the block with doctors, addresses, phone numbers, and emails. Here, it is advisable to build the structure through related tables rather than duplicating information in each record. This significantly simplifies file maintenance and further scaling.
Before the assessment, we would like to clarify one point: is this currently one working file for one operator, or are multiple employees working simultaneously with the table?

Budget: 3000 UAH Deadline: 3 days

Good day

I have experience in automating complex business processes in Excel, including VBA, Power Query, Power Automate, and developing additional logic in Python. I have worked with large tables, multi-level relationships between data, automatic data transfer between files, and creating user-friendly interfaces for operators.

From your description, I see that the main task is not only to automate data transfer but also to properly structure the data for further scaling and ease of use for users.

For implementation, I plan to use a combination of Excel Tables, Power Query, and VBA, which will allow:

• to automate data transfer between files;
• to manage the process through buttons, checkboxes, or other interface elements;
• to set up the logic for sequential transfer between tabs;
• to automatically handle scenarios for transitioning to the next patient;
• to minimize data duplication;
• to build a normalized table structure for working with doctors, addresses, phones, emails, and other related entities;
• to ensure further functionality expansion without the need for a complete file overhaul.

I also have experience in optimizing slow Excel files and building stable workflow solutions for operators, where reliability, ease of use, and minimization of manual actions are important.

I am ready to thoroughly review the current files and propose an optimal implementation architecture. We can discuss the details in private messages. Expand

Budget: 1000 UAH Deadline: 3 days

Good day!

I am a specialist with advanced knowledge of Excel, VBA, Power Query, and Power Automate. I am ready to optimize your file, automate data transfer, build a logical structure of tables, and provide a user-friendly interface for operators.

I have experience in implementing complex workflow logic. Message me privately to discuss the details.

Budget: 22000 UAH Deadline: 20 days

Good day. I specialize in creating programs for automating various processes. I am not familiar with VBA / Macros - but everything can be automated in Excel using Python. It is also possible to automate in Google Sheets. Additionally, a desktop program can be written if it needs to work as a user.

Budget: 5000 UAH Deadline: 2 days

Good day! I have a very large experience working with spreadsheets, particularly Excel, as well as with VBA macros and Python!!! My main projects completed on this platform are specifically related to ET and programming!!! I am ready for discussion!!!!!

Budget: 2500 UAH Deadline: 7 days

Good day! I am implementing Excel automation in Python (openpyxl):
— automatic data transfer between files with operator selection option (checkbox/button)
— logic for sequential transfer between tabs
— convenient table structure for working with patients (one doctor — multiple addresses, contacts, locations)
— minimization of manual duplication, user-friendly interface for operators
Additionally, I understand the specifics of the medical field — I have experience working in a medical institution.
Tools: Python + openpyxl. I am ready to review the file and clarify details before starting.

Budget: 4000 UAH Deadline: 5 days

Anastasia, good day.
I developed automation and add-ons for the Armed Forces of Ukraine where the tables have more than 10,000 rows.
VBA, C#, Power Query.
Feel free to contact me, we will discuss, I will show examples, we will agree.
The deadlines and time are approximate, more precise after familiarization with the files and their structure.

Budget: 2000 UAH Deadline: 3 days

Hello! Your project looks very interesting. I am ready to start working immediately and ensure high quality.