Macro or script for Excel
45 USD It is necessary to write a macro or script for Excel. The technical specifications are in the attached video file. I would like to note that the file we are working with can contain up to 20,000 rows and may have a varying number of columns.
I am also attaching the file for work in the technical specifications - the file is in csv format.
Applications 2
Client's review of cooperation with Viktor Biruk
Macro or script for ExcelI am very satisfied with the work done! Viktor is a true professional, he wrote a macro that fully meets the specifications and works veeeery quickly, even improved what was not included in the specifications. I recommend him for collaboration!
Freelancer's review of cooperation with Anna Kosova
Macro or script for ExcelClearly defined task, pleasant communication, quick responses to arising questions and corrections - what else is needed to complete the work? )
-
2 days45 USD
2 days45 USD
Good day, I will help you complete the task. My experience and technical skills meet the requirements of the terms of reference. I will propose an optimal solution. Feel free to reach out.
-
3 days111 USD
1138 38 0 3 days111 USD
So it is possible to do this. The comment added here regarding whether it will work quickly is 100% true. But I am sure that a solution can be found. I can automate this for you using a macro and some other Excel capabilities.
-
1 day45 USD
968 90 0 1 day45 USD
Hello, Anna.
I am ready to do it by morning.
-------------------------
-
1 day45 USD
3668 107 0 1 day45 USD
Yes, everything you described in the video is possible... The only thing is that the script that highlights the rows will take a long time to run if there are 20,000 rows... Is it possible to split such files into several?
-
5 days45 USD
957 19 0 5 days45 USD
Good day!
I understood the task, I will help implement a simple automation method.
Here is the implementation.
https://prnt.sc/COgyCixHh6mt
In your file, I changed the names to demonstrate that the same name will be highlighted the same way.
Write to me, I will send the code, explain how to use it, and set up a keyboard shortcut for quick execution.
-
2 days45 USD
5911 345 0 2 days45 USD
I can do it if you provide clarification on how exactly to shade the cells (whether it should just visually separate the groups or if the color depends on the data itself) and what data needs to be cloned in each group.
-
2 days45 USD
353 22 0 2 days45 USD
Good day. Please write to me in private. I will be happy to help. Feel free to reach out, we will discuss the details.
-
1 day45 USD
567 28 2 1 day45 USD
I looked at the project brief, of course, everything is possible to do. I have a few questions, write to me and we will communicate.
-
1 day45 USD
3443 86 1 2 1 day45 USD
Good day. I am ready to create a macro for Excel that will perform color highlighting and data copying according to the specifications.
I guarantee speed and quality.
-
2 days45 USD
3012 73 4 2 2 days45 USD
Good day! I have experience = I can do it well!!!!!! Feel free to contact me!!!!!!
-
Добрый день, на 20000 строк и такое количество колонок которое нужно обработать, даже с мощным компьютером и 2013 офисом может уйти часов 8. Вы готовы будете ждать так долго каждый раз?
-
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 1 day 14 hours back ∙ 51 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day 15 hours back ∙ 12 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 3 hours back ∙ 10 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 9 hours back ∙ 12 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 7 hours back ∙ 25 proposals |
Kyiv