The Exell VBA Macro
4 USD There is a macro that compares the columns of two different Exel files.
It works like this:
Select in the first file 1 column (article of the product),
This is a comparison and two columns with a value.
In the second file, select column 1 (the item of the product),
The second column and the second column where they are placed.
2 columns of the first file.
After the end of the value is stored in the second file.
The task of improvement:
The problem is that in the second file the item is repeated, and the value is assigned only once.
We need to change the logic:
We take the 1st column (Articles) 2 file we look for the 1st column 1 file, we take its value from 2 columns and put it in 2 columns of the second file.
Columns are selected on their own.
Applications 1
Work results
Client's review of cooperation with Mykola Dudych
The Exell VBA MacroEverything is done according to order and in time. I recommend
Freelancer's review of cooperation with Vadim Panchenko
The Exell VBA MacroThe clarity and clarity of the task set, the timing of payment, I will be happy to work in the future. Thank God the Father, and thank Jesus for this client.
-
Winning proposal1 day4 USD
1312 37 0 Winning proposal1 day4 USD
Hello to you.
Ready to fulfill your task. Experience in writing macros.
I will be happy to cooperate.
-
1 day4 USD
3668 107 0 1 day4 USD
Can you show the Excel file itself?
And do you not consider the transfer of the macro to the Google table?
Current freelance projects in the category Desktop Apps
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 16 hours 18 minutes back ∙ 94 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 2 days 23 hours back ∙ 42 proposals |
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 8 days 15 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 9 days 2 hours back ∙ 6 proposals |
Kyiv