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
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 hours 56 minutes back ∙ 7 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 9 hours 13 minutes back ∙ 10 proposals |
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 ∙ 1 day 11 hours back ∙ 107 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 ∙ 3 days 18 hours back ∙ 43 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 ∙ 9 days 9 hours back ∙ 10 proposals |
Kyiv