Macro for sorting a table in Excel
56 USD There is a table with data, which has a column - Client and other columns.
The macro for the client column activates the filter, selects the first value from the list - "Client1".
It copies the filtered data, creates a new Excel file in the specified folder, names it Client1, pastes the filtered copied data into it, and saves it.
Then it returns to the main table, selects the next value - "Client2" and repeats the procedures until it has performed actions with all values available in the filter of the column.
As a result, we should obtain a folder with files named from "Client1" to "Last Client", each containing the filtered and copied data for a specific client from the main table.
Applications 1
Client's review of cooperation with Aleksandr Pomazun
Macro for sorting a table in ExcelEverything is great, everything is satisfactory! Completed quickly and with quality. Thank you for the work.
Freelancer's review of cooperation with Kostya Kondratyuk
Macro for sorting a table in ExcelEverything went very well, pleasant communication, quick completion of the project.
-
432
1 day53 USD
1 day53 USD
Kostya, Hello!
I will do it for 1499.
It’s beneficial for you, and for me, the first positive reviews, so I am confident that you will like the result!
I can quickly automate this in Excel: the macro will go through all the values in the "Client" column, filter each client, create a separate file with the required name, and save it in the specified folder.
I have worked with large tables, filters, registries, and data processing, so I will make the solution neatly and without unnecessary manual actions.
If needed, I will immediately consider protection against empty values and duplicates.
-
2 days53 USD
2 days53 USD
Hello! I can write this macro for you. I will create a VBA macro that will automatically filter data by the Client column, create separate Excel files for each client, copy the filtered data there, and save everything in the specified folder. The macro will work with all clients automatically - from the first to the last.
-
2 days56 USD
330 1 0 2 days56 USD
Good evening, Mr. Kostiantyn
I can take the order for work.
It will take 2 working days, and the cost is indicated in the rate. I would be happy to discuss the details and proceed with the collaboration.
-
1 day56 USD
348 1 day56 USD
Hello.
The task is clear. I am ready to create an Excel macro that will automatically split the main table into separate files for each client.
Here’s how I will implement it:
— the macro will find the "Client" column;
— it will gather all unique client values;
— it will sequentially filter the table by each client;
… — it will copy the headers and all filtered rows;
— it will create a separate Excel file for each client;
— it will save the files in the selected or specified folder;
— the file names will correspond to the client names;
— I will account for forbidden characters in file names, empty values, and duplicates.
I can also add a button in Excel, for example, "Split by Clients," so you won’t need to manually run the macro through the VBA editor.
I work with table processing, Excel/CSV, filters, large volumes of data, and automating routine processes, so I understand the logic of such a task well.
Before the final delivery, I will test it on sample data to ensure that there are separate files for each client in the folder with correctly copied data.
I am ready to execute it today.
Cost: 2500 UAH.
Deadline: 1 day.
-
2 days67 USD
1344 6 0 2 days67 USD
Good day! The task is clear, I will implement it through a VBA macro. The logic is standard — a loop through unique values in the "Client" column, filtering, copying, creating a separate file for each client and saving it in the specified folder. I am ready to do it quickly.
-
1 day53 USD
326 1 day53 USD
Good day. Konstantin
I have extensive experience in analyzing and maintaining Excel spreadsheets.
I have the time and desire to help you solve this task.
Quickly and efficiently. We can lower the budget to 1400 UAH depending on the volume of the main table.
-
1 day56 USD
4461 102 0 1 day56 USD
Good day. I fully understand the task. I will complete everything quickly and efficiently!
-
1 day56 USD
986 12 1 1 day56 USD
I have extensive experience in creating analytical reports in Excel and optimizing processes through automation with macros, which reduces manual work.
-
2 days56 USD
357 2 days56 USD
Good day! I am implementing a script in Python that automatically reads Excel, filters data for each client, and saves a separate file named after the client in the specified folder. I am using pandas + openpyxl. I am ready to start immediately.
-
3 days56 USD
1473 45 1 3 days56 USD
Hello! I am ready to implement a VBA macro for automatic data distribution by clients. The macro will sequentially filter data by the values in the "Client" column, create a separate Excel file for each client, copy the corresponding rows, and save the files in the specified folder with automatic naming based on the client's name.
I have experience in creating Excel macros for processing price lists, automating routine operations, and working with CRM systems. Before starting the work, I am ready to familiarize myself with the file structure and clarify the details.
-
4 days56 USD
432 1 0 4 days56 USD
Hello! I will create a VBA macro for Excel that will automatically go through all the values in the "Client" column, filter the data, create separate files, and save them in the specified folder with the names of the clients.
-
1 day56 USD
2257 35 0 1 day56 USD
Hello, I am ready to help you complete this. I have professional skills and experience in similar projects. I will offer an optimal, continuously working convenient solution. Feel free to reach out.
-
1 day56 USD
277 1 1 1 day56 USD
Hello, I can complete this task quickly and efficiently, in just one day for a payment of 2000 UAH. Contact me, I am ready to start the task.
-
2 days56 USD
2751 265 0 5 2 days56 USD
Hello! I have already automated similar tasks in Excel using VBA macros multiple times. The script will work reliably: it will filter the data by itself, create separate files for each client, and save them in the specified folder. This will save you a lot of time on routine tasks. Let's discuss the structure of your table so that I can customize the macro to your needs.
-
1 day56 USD
182 1 day56 USD
Good day.
I have reviewed the task and will implement it through a VBA macro. The structure of the file is clear, so I can start working on it right away. I am ready to complete it today or tomorrow.
-
1 day56 USD
2864 72 0 1 day56 USD
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 separate processing workbook.
Initial settings:
- In the system window (which will open after launching the program), select the file with the data;
- If you need to choose a location to save the folder with new files, specify the directory for saving in another system window.
The program will handle everything else on its own. The macros will not use a slow filter; the program will be fast and user-friendly.
… Write to me, we will make it happen.
-
1 day78 USD
254 1 day78 USD
Good day!
I can implement such a macro for Excel.
The task is clear: it is necessary to automate the distribution of the main table by the values in the "Client" column — filtering each client, creating a separate Excel file, copying the corresponding rows, and automatically saving them in the specified folder.
I will implement a macro that:
— retrieves all unique values from the "Client" column;
— sequentially filters the data;
… — creates a separate file for each client;
— transfers only the necessary records;
— saves the files with corresponding names.
I am ready to create a solution tailored to your table structure and test it with an example.
-
1 day56 USD
1312 37 0 1 day56 USD
Good day. I have experience in writing macros for Microsoft Excel. I am ready to start working.
-
1 day56 USD
2991 73 4 2 1 day56 USD
Good day! I have a lot of experience working with Excel macros!!! The task is clear - I will take all nuances into account!!
Feel free to contact me, I will deliver quality work!!!!
-
14 days56 USD
957 19 0 14 days56 USD
I will create a macro that will generate files with all the values from the Client column. If there are rows where the Client column is not filled, it will create the corresponding file.
If any additional details need to be considered, I will try to implement them.
Can similar client names be used, for example "Furgon-Service" and "Furgon Servis" (the difference: a space instead of a dash)? In such cases, an additional check can be made and the file can be split considering this nuance.
-
2 days56 USD
676 13 0 2 days56 USD
Good day! I will complete your task.
_________________________________________
-
Winning proposal3 days56 USD
4831 376 2 3 Winning proposal3 days56 USD
Hello. I am ready to complete your task. Please provide a test Excel file.
-
1 day56 USD
1728 22 0 1 day56 USD
Good day. I am ready to provide you with such functionality. Feel free to reach out.
-
deleted by moderator
-
deleted by moderator
-
Current freelance projects in the category Data Processing
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 5 hours back ∙ 14 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 5 hours back ∙ 16 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 3 days 14 hours back ∙ 10 proposals |
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 5 days 12 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 12 days 13 hours back ∙ 20 proposals |
Kyiv