Create macro for Excel for Mac OS and Windows
22 USD It is necessary to make a macro in EXCEL, which brings the data in the correct form.Macro should work both on Windows and MAC OS (there are 2 macros for different OS)
In the first column of the EXCEL file we will enter the data.(Many lines at the same time)
The second column will contain the buttons to get the result.
3 columns = (individual number of position)
From the data of the first column of the corresponding line there are numbers equal or longer to 4 characters, which may include letters.
If in the first column there are two such numbers, then there falls first a longer number and through the gap next "(" short number ")"
4 columns = (named)
Here the word or several words pass through the gap that is contained in the corresponding column of the first line (symbols there may be)
Words are longer than two symbols (signs in length are not considered)
Excluding the words:The couple.and comp.Completed , st
If not, then leave it empty.
5 columns = (columns)
Search for separate numbers in 1 column of the corresponding line (the closest to the left boundary of the cell) not more than 99 or not price numbers example:1.7 not more than 99
If not, then leave it empty.
6 columns of measurement
Search in the first column and the corresponding line of the word:The couple.and comp.Complex, M and M,m and put them in column 6 (if they are) If not, leave it empty
7 columns ( price )
Search for the numbers after which there is the name of the euro and before which there is "-" and put them in the cell / You need to make the second version of this column (Seek the numbers near the right edge and before which there is "-" and put them in the cell)
If not, then leave it empty.
Column 8 number
This is a short number like in column 3, but only a short number.
If not, then leave it empty.
Column 9 number
This is a "long number" like in column 3, but only a long number.
If not, then leave it empty.
For those interested in the project, I can send examples of files.
Client's review of cooperation with Oleksandr Nazarov
Create macro for Excel for Mac OS and WindowsEverything is done perfectly!
The execution has done a lot of additional work that we didn’t discuss at first.
The professional. I advise everyone!
Freelancer's review of cooperation with Igor Igor
Create macro for Excel for Mac OS and WindowsEverything was great, constantly in contact, it was pleasant to work.
-
Winning proposal2 days22 USD
812 15 0 Winning proposal2 days22 USD
Good night, I will do it, call me. Here is an example of the file. It will work on both systems if you have MS Office installed on the Mac.
and ........................
-
1 day4 USD
1115 109 0 1 day4 USD
Good day Igor.
Write to Ls, we will discuss the details. You need original files.
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 3 days 11 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 3 days 23 hours back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 11 days 12 hours back ∙ 10 proposals |
Kyiv