2 Macro VBA in Excel
11 USD On the first list there is a standard type of state.Examples on land areas (will be uploaded by the user to Excel from PDF).Example of the "Data Introduction (Macro 1)" sheet.In the file a short example, and in real life 10,000+ lines.From the lines on the first list, the macros must load all the numbers from these pieces of text (lighted red in the document):
Number of registration: 1234567
* Description of the object: Area (ga): 0.9452
Date of expiry: 31.12.2028
And then the macro must load out 3 columns on the second sheet, starting from cells A2, B2 and C2 (Exit macro 1).I will give examples of these people.A list to whom you need to understand better.They are 99% standard.Sometimes the lines can change in places, but the text is the same everywhere.Macro No. 2
Example on the list "Data Introduction (Macro 2)" and "Exit (Macro 2)".The user enters the data in the columns A, B and F. Macros takes all the areas from the columns A:B (but only the areas with the data in the columns F = 1).The macros forms several text blocks, a maximum of 80 parts in 1 block (we have a system limit of 80 cadastroes per 1 block...)by the text given from cells, as in the example.In the text, you will need to use 1 formula (fertility * seed).The macro removes the text fields to the next sheet (Macro output 2).There are examples.Important: Calculations should be done inside the massive, not on the screen (to accelerate the work of the macro)
Both macros need to be created in the file in the deposit so that I can test by entering other state outlets on the first and third sheets.
Applications 1
Client's review of cooperation with Oleg M.
2 Macro VBA in ExcelEverything is great, I recommend! I did better than I needed!
Freelancer's review of cooperation with Nikolay Oli
2 Macro VBA in ExcelIn fact, the task is more difficult than it seemed at first. But with Nicholas, they checked everything, made it foolish and even increased the budget a little bit. I will be happy with new orders.
-
Winning proposal1 day11 USD
1115 109 0 Winning proposal1 day11 USD
Hello to Nicholas.
I specialize in macros for Excel. There are a lot of relevant reviews in the profile.
I got acquainted with the TZ and the example of the file.
I can write the necessary macros in a few hours. I do it immediately upon approval of the project.
For the first macro tests, more source data will be required.
-
1 day11 USD
1138 38 0 1 day11 USD
Good day . Get acquainted with the task. I know how to accelerate the work of the macro. I will do everything under the right buttons in that file.
Excel and everything related to it for many years has been my main work tool.
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 9 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 ∙ 2 days 23 hours 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 6 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 12 hours back ∙ 24 proposals |
Kyiv