Excel file (with macros) to update prices
11 USDДобрый день! Нужно сделать файл для обновления цен. Артикулы (коды) товаров нужно сравнивать у файла поставщика и файлах магазина и менять цены и наличие.
Еще необходимые детали: окрашивать обработанные строки в желтый цвет, а содержащие определенное слово в зеленый.
Для формулы наценок и наличия нужны справочники (отдельные листы).
Набросок прикрепляю во вложении.
Applications 1
Client's feedback on cooperation with Ivan Moroz
Excel file (with macros) to update pricesThe task is fully resolved. Thanks to the number of directions, the program was able to work properly. Thank you for your collaboration, I will be happy to contact you again.
Profile deleted | Safe
Freelancer's feedback on cooperation with client
Excel file (with macros) to update pricesConstantine is a very responsible customer.
During the entire time of the project was in contact, and immediately responded to all the questions that arose during the process of implementation.
pleasant to collaborate.
I strongly recommend.
-
922 99 0 Hello to you!
I have written a few times for work with the prizes.
Go to turn.
Здравствуйте!
Уже не раз писал макрос для работы с прайсами.
Обращайтесь.
-
355 20 0 Good day . Ready to implement your project. More detailed examples of the input and output file are needed.
Добрый день. Готов реализовать Ваш проект. Нужны более детальные примеры входного и выходного файла.
-
675 28 1 What is the total amount of data? There are ready solutions, you just need to adapt to your needs. It’s better to connect with Skype Sokolv555.
Общий объем данных какой? Есть готовые решения, нужно только адаптировать по Ваши нужды. Для связи лучше скайп sokolv555.
-
256 19 1 1 I will write a macro that will perform the assigned task. Details before discussion.
Напишу макроса который будет выполнять поставленную задачу. Детали до обсуждения.
-
1954 35 0 Hello to you.
Ready to perform.
I am the one who gives me the gift, the one who gives me the gift, the one who gives me the gift.
Здравствуйте.
Готов выполнить.
.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.
-
565 85 3 6 Good morning, I suggest implementing a software that will do the same, the result can be in Excel or other convenient form for you, interested in more details starting from where to get the data
by p.s. Do not do in the axle where you need macros that in the future will need to expand, at one point the axle will begin to fool or further expansion will become impossible.
добрыйдень, предлагаю реализовать ПО которое будет делать то же самое, результат можно в ексель или другую удобную для вас форму, интересует больше деталей начиная с того откуда брать данные
P.s. не делайте в екселе то, где надо макросы которые в дальнейшем надо будет расширять, в один момент ексель начнет тупить или дальнейшее расширение станет невозможным
-
2605 79 0 Ready to do.
‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘‘
Готов сделать.
''''''''''''''''''''''''''''''''''''''''''''''
-
Данные у поставщика и магазина на одном листе у каждого или разбросаны по разным листам?
-
в принципе там несложная формула, если не выбирать лист а в листы для сравнения вставлять необходимые прайсы
-
Current freelance projects in the category Application programming
Automatic dialing program
200 USD
It is necessary to write a program for calling employees of the company. There is an Asterisk server, SIP account, the administrator has allocated 5 lines. The database is stored locally. The operator should form the call database: 1. Full name 2. Position 3. Phone number 4.… IP-telephony and VoIP, Application programming |
Import products to Simpla website and update themHello, you need to import products through data export. There are different export formats - csv, xml, xls. Also, it is necessary to update the availability of products from a Google spreadsheet. It is required that products with the same SKU from different sources (currently… Web programming, Application programming ∙ 3 proposals |
Develop a smart home on Raspberry.make friends with some touch screen with raspberry When the screen is loaded, there should be 10 pictures and all when you click on the picture with the image of a light bulb, signal 3v one should be when you click on the picture with the image of a kettle, signal 3v another… Application programming |
Set up the feed for exporting goods from Horoshop to KastaSet up a feed for exporting products from an online store on the Horoshop platform to Kasta, according to Kasta's requirements and instructions. 4-5 product categories, up to 50 products per category. Data parsing, Application programming ∙ 2 proposals |
Make importing goods to the Simpla website and updating themGood day, you need to import goods from the upload. There are different upload formats - csv, xml, xls. Also, it is necessary to update the availability of goods from Google Sheets. Web programming, Application programming ∙ 2 proposals |