Excel macro
5 USD 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.
-
Winning proposal1 day5 USD
418 37 0 1 Winning proposal1 day5 USD
Good day .
I do it quickly and quality.
If you are interested, write to L.S.
Current freelance projects in the category Data Parsing
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 ∙ 5 hours 5 minutes back ∙ 4 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 ∙ 7 hours 2 minutes back ∙ 23 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 14 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 14 hours back ∙ 31 proposals |
Need a parser for the online store https://www.lcsc.com/It is necessary to regularly (once a month, or upon script launch) obtain up-to-date information about the products available in the store. https://www.lcsc.com/ from the catalog of all sections.… Data Parsing ∙ 3 days 20 hours back ∙ 43 proposals |
Kyiv