Write the macro in Excel to download from the site
11 USD I have a old website, now a new website. To correctly transfer goods from the old to the new I need the old download from the site to a new format (excel download).
In the new loading are different types of fields, their sequence, etc. I began to do this in the hand and at the 300m item I realized that I would spend another half of my life on it. There are 7,000 other goods.
As far as I understand, it can be done through macros (or some other way that I don’t know).
I'm waiting for answers from those who have faced this and can help to automatize this process, manual filling is not interested, as at the moment time is very pressing.
PS Old and new loading, instructions on how I did this hand I will provide separately.
Client's review of cooperation with Dmitry R.
Write the macro in Excel to download from the siteSmoke, thank you for your work! For me, the task was not easy, as a few programmers were never able to do this work in a week, and Dima did it in less than 2 days.
He was always in contact, even later, giving his advice and asking the right, understandable questions.
In general, the professional of my business, I definitely recommend I will address in the future!
Freelancer's review of cooperation with Aleksey Fedorenko
Write the macro in Excel to download from the siteAlexey set the task and organized the process for its implementation. I received the necessary information quickly. They worked closely with Alexei's team and performed the task faster than planned, which is not just my merit. I recommend working with such a customer.
-
2 days13 USD
2437 76 0 2 days13 USD
Alexey good day!
I am engaged in financial reporting automation, a great experience in working with Excel. I will adjust you a new file with the products, you need to see, it may get without a macro.
Please contact me and I will be happy to collaborate:
Posts by: ama1_28
Skype: Ama1_28
Post by: [email protected]
-
2 days22 USD
313 58 0 2 days22 USD
I have a great experience of successfully solving the most unstandard tasks in Excel including. for the breakdown, preparation of data for import to websites. I have the skills to work with the “decimal” formulas, write the macros. Send the files, we will finally agree on the price. Look at recent reviews, a similar project has been successfully completed.
-
5 days18 USD
4802 376 2 3 5 days18 USD
It’s hard to pay for something without seeing the amount of work.
Please give an example of a couple of lines.
-
1 day22 USD
399 1 day22 USD
I will meet.
I will determine which of the unknown methods you need to apply.
I do it.
-
1 day22 USD
2123 85 0 1 day22 USD
Готов сделать.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
-
1 day22 USD
221 6 1 1 day22 USD
Ready to meet. I book for free. The price is not for "to get acquainted" and can be very conditional.
-
2 days22 USD
2748 153 0 1 2 days22 USD
Hello to you. Ready to meet.
-
Дайте файл и инструкцию.
-
Елки, иКСТРУНций (как говорил мой сын) в Интернете немерено - просто сохраните дамп в формате csv, а потом он автоматом и портируется в любые БД. А в Экселе он автоматом откроется. )
-
И если нужно что-то изменить (ту же структуру) вы его откройте, измените и сохраните как csv. Все в принципе.
Но возни будет много. ( -
Вы бы написали, откуда и куда портировать. Ответы были бы конкретнее.
Хотя, по сути, если вы сами примерно знаете как, и вам только совет нужен, то, думаю, мой поможет. ) -
Если сумбурно написал (непонятно), то пишите в личку - Вообще, на уровне Экселя, это делается путем драг-энд-дроп - простого перетаскивания,, но лучше сделать дамп и парочкой запросов к БД сотворить новую структуру. Что первый, что второй вариант, займут примерно одинаковое время.
-
Current freelance projects in the category Databases & SQL
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 1 day 2 hours back ∙ 28 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 4 days 5 hours back ∙ 18 proposals |
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 days 22 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days 16 hours back ∙ 92 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 5 days 19 hours back ∙ 18 proposals |
Kharkiv