Excel macro
There is a file folder - you need to enter each file and do one-type operations:
1 . Multiply the value in the column *Articles* by 2 (and replace the current value with a new)
2nd Apply the formula =CURRUM(column value*0.95;0) for 2 columns - *Price* and *Old price*
Three Remove data in two columns -- *id (not edited) * Status (not edited) *
4 . Apply the replacement of "i" on "ta" , "or" on "ale" in columns -- * Description (text)[ru]* * Description (text)[ua]*
and 5. Remove the text in the spots () together with the spots in two columns -- * Name of the goods*[ru]* * Name of the goods*[ua]*
Added files for example.
Applications 2
Client's review of cooperation with Artur Dovbysh
Excel macroArthur quickly disappeared in the TZ and began to perform. Everything is fast and clear. I recommend !The !
Freelancer's review of cooperation with Ihor Freelance
Excel macroEverything is great and understandable.
I'll be happy to sport again.
-
418 37 0 1 Good day .
I do it quickly and quality.
If you are interested, write to L.S.
Current freelance projects in the category Data Parsing
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 hours 51 minutes back ∙ 17 proposals |
It is necessary to process the database so that the output files are in the formatThere is a database of the forum and files of the XENFORO 1.6 forum. It is necessary to create an import file for another script, but all fields must be preserved. I provide the specification files and the FAQ file which specify the fields I need. The specification files are for… Databases & SQL, Data Parsing ∙ 9 hours 44 minutes back ∙ 11 proposals |
Parsing products from supermarketsNeed a specialist (parsing + Google Sheets + automation). Goal: Create a system for automatic retrieval and updating of food prices from Silpo and NOVUS supermarkets with data output to Google Sheets. What needs to be implemented: Create a main Google Sheets table with a product… Data Parsing, Information Gathering ∙ 11 hours 41 minutes back ∙ 33 proposals |
LinkedIn mailing
120 USD
LinkedIn Mailing It is necessary to launch a LinkedIn mailing to the specified database. 30,000+ contacts We are waiting for proposals Email Marketing, Data Parsing ∙ 1 day 19 hours back ∙ 9 proposals |
Parsing company emails from a specific industry
113 USD
Find contacts (e-mail, phone number) of companies engaged in the specified business mentioned in this Google document https://docs.google.com/document/d/1_d-iLxLSL3gjRvo1GmUpWNm0Pm5YoKGcEvaiDc_2I0g/edit?usp=sharing The result should be in the form of a table with the following… Data Parsing ∙ 2 days 19 hours back ∙ 31 proposals |