Macro Excel
8 USD 1 . When the macro is launched in the dialog window, the user chooses which groups to extract the report (multiple selection) and, if necessary, puts the rubber in the "divider" field. In the new book, only the list of emails in the columns is drawn out. If the active "Distributor" button - after each has a sign is placed ; and the gap
2nd During the work, the macro divides the emails and moves them into the columns one under the other.
Three Repeated emails across the list are deleted (only 1 of the repeated emails remains)
4 . The report contains only the values corresponding to Criterion 2. Everything with Criterion 1 is ignored.
and 5. If new groups are added to the report, they will automatically have to be added to the dialog window when the macro starts.
Examples of work. Type of data after macrowork
Applications 1
Client's review of cooperation with Ivan Moroz
Macro ExcelA very good specialist. He completed the task in time and quality, the result is satisfied
Freelancer's review of cooperation with Vladislav Savenkov
Macro ExcelResponsible Customer,
I strongly recommend!
-
Winning proposal1 day8 USD
744 99 0 Winning proposal1 day8 USDGood day .
Ready to help. He did such a job. I will be happy to cooperate
-
4 days11 USD
38 4 days11 USD
Good day .
I am ready to write this macro.
The cost will be 500 UAH.
Go to turn.
-
2 days7 USD
1312 37 0 2 days7 USD
Hello to you.
Experience in writing macros.
I will be happy to cooperate.
-
1 day9 USD
2073 116 0 1 day9 USD
Hi, I can write a program to process your Excel file, but you need to clarify the details.
-
1 day9 USD
552 70 13 2 1 day9 USD
Ready to do. The task is generally clear - in addition to what is behind the "Distributor" button and why it is.
-
2 days11 USD
3418 53 0 2 days11 USD
Hello to you. Ready to perform in the best way. Please, we need to discuss details
-
1 day11 USD
2162 85 0 1 day11 USD
Готов сделать.
ооооооооооооооооооооооооооооооооооооооооооооо
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 3 days 13 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 3 days 16 hours back ∙ 19 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 5 days 7 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 6 days 12 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 6 days 16 hours back ∙ 13 proposals |
Kyiv