Create a macro in Google Sheets
Good evening!
The first sheet is the starting page for uploading prices.
I took the information from the supplier's price list (article and price in currency (the currency can only be one) I duplicated, it showed me in hryvnias in the second column
Your task is to take the article from the first sheet and search in the second sheet, and make a comparison in (Supplier article, and Article in the records
Conditions:
(L1 - first sheet, column A)
If the article L1 MATCHES with L2 Supplier article, then the price from the first sheet is duplicated to the second sheet (RRP price) and the next article is processed.
If not, then this same article is checked with the second column and compared, if found, the price is set, then it means one of the article options will be correct.
If it was possible to find one of the articles and change the price, it is written successfully, so I understand that everything has been uploaded
If not, it is written unsuccessfully, so I can see what the problem is and may make corrections.
Please write the cost of such work, maybe you will have some questions, feel free to ask, I will explain the task more precisely.
Thank you for your attention.
-
1 day22 USD
1 day22 USD
Good day
I will quickly and efficiently complete your task using formulas or a script. I will finish it within an hour at most. I am ready for ongoing collaboration on similar tasks.
Feel free to contact me.
-
1 day33 USD
250 37 1 2 1 day33 USD
Good day
I will quickly and efficiently complete your task using a macro.
-
1 day22 USD
656 9 0 1 day22 USD
Good evening, Franklin!
In general, the task is clear, but for an accurate response regarding deadlines and price, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages – we will discuss the details and your wishes.
-
1 day22 USD
986 12 1 1 day22 USD
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!
-
3 days33 USD
272 5 0 3 days33 USD
Good day!
I am ready to complete your task of reconciling items between two sheets and automatically updating prices. I will write a macro that can be used in other projects. I have carefully familiarized myself with the logic: searching for an item from Sheet 1 in two columns of Sheet 2, setting the price upon a match, and recording the status as "successful" or "unsuccessful" for each row. This type of work is well known to me, as I regularly perform data reconciliations, price updates, and structured processing of tables.
I am ready to carefully set up the process so that you can clearly see where the prices have been updated correctly and where verification is needed.
I am ready to start immediately after clarifying the details. I look forward to collaborating.
-
1 day20 USD
2578 57 1 1 1 day20 USD
I work as a financial analyst in a large international company. I will do it, I have extensive experience.
-
1 day22 USD
10299 129 0 1 day22 USD
Good day
The task is clear, something similar is constantly written in one form or another.
-
1 day16 USD
5894 345 0 1 day16 USD
I can create a macro for Google Sheets that will compare items and update the price and status "successful/unsuccessful."
-
1 day16 USD
669 8 0 1 day16 USD
Good day.
I can complete your task, I have experience in such tasks.
Feel free to contact me.
-
1 day16 USD
981 17 0 1 day16 USD
Hello!
I can complete this task with a script and formulas. Please feel free to contact me)
-
1 day112 USD
288 1 day112 USD
hi.
Your task can be implemented exactly as described.
I will take each article from Sheet 1 column A and search for it in Sheet 2.
First, it will be compared with the Supplier Article column.
If no match is found, it will be compared with the second article column.
When a match is found, the price from Sheet 1 will be written into the RRP price column in Sheet 2.
For every article, the system will record whether the update was successful or unsuccessful so you can see which items need correction.
… You can choose the implementation format: Excel formula, Excel VBA macro, or Google Sheets script.
Estimated cost is 25 to 40 euros depending on the format.
Delivery time is about one to two hours after receiving the file.
You can send the file if you want me to check it more precisely.
-
1 day16 USD
354 1 day16 USD
Hello!
I am ready to take on your task. I will correctly match the items between the sheets, transfer the corresponding prices, and check the accuracy of each position. I work carefully and quickly, without mistakes.
I am ready to start immediately.
Cost of work: 250 UAH.
-
1 day16 USD
1312 37 0 1 day16 USD
Good day.
I have experience in creating Google Sheets and writing Google Apps Script.
I will be happy to collaborate.
Current freelance projects in the category Data Parsing
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 1 day 22 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 2 days 3 hours back ∙ 16 proposals |
Need to scrape data from LinkedIn
We need to scrape data from LinkedIn based on our list. For each entry, we need to find and collect available data if it exists on the LinkedIn profile, including the profile picture on the LinkedIn social network, email address, links to social media, company website, and… Data Parsing ∙ 2 days 8 hours back ∙ 27 proposals |
Parsing and classification of data
We are looking for a developer to implement a system for collecting and structuring data from open sources. We have a database of small business owners in the USA, which contains the person's name, company name, address, and state. It is necessary to build a process for… Web Programming, Data Parsing ∙ 2 days 9 hours back ∙ 41 proposals |
Svitlahata
17 USD
It is necessary to import 1819 products from the XML/YML feed of Prom.ua to OpenCart 3. A ready XML file is available, which contains product names, descriptions, prices, photos, specifications, manufacturers, and categories. Requirements: import all products to OpenCart… Content Management Systems, Data Parsing ∙ 3 days 12 hours back ∙ 34 proposals |
Odessa