Program to compare 2x Excel tables by assigned parameters
The first table of the taxation on private bank payments, the second table is the OLAP report on the taxation from the trading program.
If the line of payment is present in both tables and the amount of payment is not more than 10 grn. Note the lines in two tables with one color (green light).
If the payment is present only in one of the tables OR in two tables, but the amount differs more than by 10 grn - note another color.
Payment comparison in both tables is made either by payment ID or (if no ID) by order number.
In the bank note negative amounts (expenses transactions) note in the third color
I'm waiting for your suggestions, attached tables that should get at the output (made manually)
Applications 2
Client's review of cooperation with Vlad Skif
Program to compare 2x Excel tables by assigned parametersThe program is written quickly, on the weekend, all wishes are taken into account. I recommend cooperation.
Freelancer's review of cooperation with Vitaly Dobronravov
Program to compare 2x Excel tables by assigned parametersEverything is good, a clear task, always in contact. I recommend cooperation!
-
2073 116 0 Good night, I can write a cell painting program. I would like to clarify a few points, and so everything is clear. Please call me, I'll be glad to help!
-
97 Welcome to Vitaly! There is a Microsoft Excell (Advanced) certificate and practical experience in writing such programs. You can paint in the original files using VBA or create a separate program on Python to generate individual files. Write, I will be happy to help!
-
1115 109 0 Vitaly, hello to you!
I write a macro on VBA with an interface to select files to be processed. It can also be determined by a separate parameter the size of the difference in the amounts of payments.
Write to Ls, we will discuss the details.
-
2662 53 0 1 Great experience in developing such applications for Excel.
The exact time and cost can be said after discussing all the details.
-
451 1 1 Good time for the day!Interested in your announcement.There is experience with payments by liqpay.Let us discuss cooperation.
The amount is indicated arbitrarily.🤔
Current freelance projects in the category Desktop Apps
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 ∙ 7 days 2 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
22 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 11 days 21 hours back ∙ 23 proposals |