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.
Budget: 1000 UAH Deadline: 1 day
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.
Budget: 1500 UAH Deadline: 1 day
Good day
I will quickly and efficiently complete your task using a macro.
Budget: 1000 UAH Deadline: 1 day
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.
Budget: 1000 UAH Deadline: 1 day
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!
Budget: 1500 UAH Deadline: 3 days
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.
Budget: 900 UAH Deadline: 1 day
I work as a financial analyst in a large international company. I will do it, I have extensive experience.
Budget: 1000 UAH Deadline: 1 day
Good day
The task is clear, something similar is constantly written in one form or another.
Budget: 700 UAH Deadline: 1 day
I can create a macro for Google Sheets that will compare items and update the price and status "successful/unsuccessful."
Budget: 700 UAH Deadline: 1 day
Good day.
I can complete your task, I have experience in such tasks.
Feel free to contact me.
Budget: 700 UAH Deadline: 1 day
Hello!
I can complete this task with a script and formulas. Please feel free to contact me)
Budget: 5000 UAH Deadline: 1 day
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.
Budget: 700 UAH Deadline: 1 day
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.
Budget: 700 UAH Deadline: 1 day
Good day.
I have experience in creating Google Sheets and writing Google Apps Script.
I will be happy to collaborate.
