Macro for Excel
There is an Excel table of products from Prom, in this table there is a column with a unique product identifier. In fact, this is the unique number of each product. It is necessary to change the price column in this price list, based on the unique identifier from another already prepared Excel where there is the same identifier as well as the correct price.
That is, it is necessary to find and compare the unique product identifiers in the two Excels and then, using this unique identifier, fill in the price column in the other.
If something is not filled in, it is necessary to notify to correct the error or fill it in manually.
Client's review of cooperation with Vladyslav Kyrylenko
Macro for ExcelEverything is excellent, good professional work, done quickly, I recommend.
Freelancer's review of cooperation with Vasyl Podolchak
Macro for ExcelGreat client. Clear task setting, quick feedback, and instant payment. It was easy and comfortable to work. I recommend collaborating and will be happy to help with future projects!
-
504 5 0 Good day
I am ready to complete the task quickly and efficiently.
I will do everything without macros — only with formulas, as this keeps the file simpler, lighter, and clearer for further work. I will match the identifiers in both tables, update the prices, and check if all items have been found.
I work carefully, focusing on results and my rating. I am ready to start immediately after receiving the files.
-
812 15 0 I will do it, feel free to contact me.
-
321 1 0 Good day
What is the macro for? This is done with Excel's built-in function. Contact me - I will do it.
-
669 8 0 Good evening.
I have experience in solving such tasks.
I will complete it quickly and efficiently.
Feel free to reach out.
-
4461 102 0 Good day. I will be happy to help. I have the necessary experience and skills. I will complete everything quickly and efficiently!
-
986 12 1 I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!
-
769 8 0 Hello!
This is a standard task for the VLOOKUP function. I am professionally skilled in Excel and Google Sheets (working with data arrays for E-commerce), so I do not need "1 day," like others.
My working algorithm:
I consolidate two tables by unique ID (using a formula).
I automatically pull in new prices.
…
Bonus: I provide a separate list of items that were not found or where an error occurred (so you do not lose any items).
I double-check and deliver the finished file to you.
Deadline: I will complete it within 60 minutes after receiving the files. Price: 700 UAH (for speed and error report).
-
5899 345 0 I can write a macro for replacing the identifier with handling of empty cells.
-
5820 153 4 3 Good evening, Vasily! I am ready to do this work for you. Please contact me!
Current freelance projects in the category Online Stores & E-commerce
Transfer of the website to Goshop with promo
111 USD
Hello! We need to transfer the website from Promo to Khorosho. Quality is essential! With translations, specifications, modifications, keep the old links and SEO, and set up a nice design. The current site generates $300 in advertising per day, so the first priority is to… Online Stores & E-commerce ∙ 4 minutes back ∙ 1 proposal |
Open and set up stores on TikTok Shop and Amazon USA
601 USD
One-time job. Need a specialist with experience in launching and promoting such stores. In the bid, please include real cases. Online Stores & E-commerce, Lead Generation & Sales ∙ 22 minutes back ∙ 2 proposals |
Online store of bed linenA small online store for bed linen. Up to 500 items. Average check 1000 UAH. A specialist is needed for advertising in Google Ads. What is the monthly payment for setup and management? Online Stores & E-commerce, Contextual Advertising ∙ 1 hour 32 minutes back ∙ 18 proposals |
Design and turnkey development of an online store and portal for the KOSA Luxury Hair brandWe are looking for a web studio, a team of freelancers, or a single specialist (designer + developer) to create a "turnkey" website for the new hair and hairstyle brand "KOSA Luxury Hair". We need a complete cycle: development of the UI/UX design for the homepage (focusing on… Online Stores & E-commerce, Website Development ∙ 7 hours 8 minutes back ∙ 57 proposals |
Export of goods from Rozetka to Epicenter
18 USD
It is necessary to transfer about 300 products from Rozetka to Epicenter and, if necessary, make edits and go through moderation. Online Stores & E-commerce, Content Management ∙ 19 hours 7 minutes back ∙ 17 proposals |