Macro for Excel
1 . Change the file coding from UTF-8 to ANSI
2nd Open the Excel file. The content called FEATURES is divided into columns.
The example
Brand: E[Breguet]; Country of production: S[Switzerland]; Mixed: S[Circular]; Color of the color: S[White]; Material_watches: S[Stall]; Style: S[Every day]; Movement: S[Automatic]; Case size: S[40-44]; Shape: S[Round]; Condition: S[New]; Water resistance: S[Yes]
We get the columns:
Three Keep in a new file.
It also provides a macro that will work in the opposite order.
The data in the file is tested. The number of columns and names can be any.
Applications 3
-
231 3 0 Good night, I just finished the project on the comparison of the data in the axles and making changes to the new file. It is good, write.
-
366 25 1 I will write a program that will perform these functions. Examples of work with Excel are in the portfolio.
-
3668 107 0 I will write you a macro that will do what you describe.
But we will have to discuss some more details...
-
2162 85 0 Готов сделать.
ооооооооооооооооооооооооооооооооооооооооооооооооо
-
303 4 0 Hello to you. There is experience in writing macros of various complexities. You can also write what is done directly from the word. Discuss some details. The price is not final either. Ready to start work. thank you. I wait for the answer.
-
это обязательно должен быть макрос?
скрипт на питоне не подходит? -
Current freelance projects in the category Data Parsing
Database of websites on WooCommerceIt is necessary to compile a database of Ukrainian online store websites on WooCommerce with the contact information provided on the sites. Only active websites (indicator: updated catalog/content, working domain) Table format - website address, phone number, e-mail. Data Parsing ∙ 1 day 10 hours back ∙ 20 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 3 days back ∙ 17 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 3 days 4 hours back ∙ 34 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 3 days 7 hours back ∙ 40 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 3 days 13 hours back ∙ 24 proposals |