Compare 2 tables in Excel VBA or in another permanent user format
Compare 2 Excel tables:
The project can be done in the VBA format or in another convenient format.Table 1 contains the correct data for accounting from the website.(Monthly new data)
The 2nd table contains the data from the system (the 2nd table must be prepared before it can be used, the order data from the system must be attached to the account data from the system in the same table.)You may need to add orders with the same order number so that the 1 order number is only one amount) The order number is used as a total value in both tables (1-2).The order number from table 2 contains additional characters that must be removed.(Table 2 is filled with new data every month)
When tables 1 + 2 are ready for comparison, they are compared by the order number.It is possible to compare only the investment with the investment or the loan with the loan, the investment and the loan are not allowed.The following values should be compared if they match (suma, currency, value added tax, country, and possibly even additional value).The values in Table 1 are correct, in Table 2 the values must be = with Table 1.If everything is right, the record should be green (in tables 1 + 2), if in one record there are errors, it should be orange (in tables 1 + 2), if in another table there is no pair (in 1 or 2) the data set should shine red.Each month, new data are received for tables 1 and 2.All the correct data (green) must be moved from both tables to the archive (may be an additional file) or removed from the macro.The macro must contain only false data and not yet verified data.The project should be in the form of a macro or in another format that is best suited.Contact me by Skype.In the beginning you need to explain a lot, so don’t ask who such a comic is not suitable.There may be changes in the course of the project if the implementation does not work properly.If you are interested, I will explain it all in Skype and show it.
Client's review of cooperation with Eduard Karpets
Compare 2 tables in Excel VBA or in another permanent user formatThank you for the project, everything is done in time.
Freelancer's review of cooperation with Eugene Yablunovskyy
Compare 2 tables in Excel VBA or in another permanent user formatI liked everything. an interesting project.
-
229 2 0 Good day ! A very interesting task. Ready to learn the details of the project and implement it.
-
702 23 0 Good day .
Ready to implement your project. Support and adjustment of the program after implementation is guaranteed. Skype is there. Before contacting Skype, please send samples of tables (a few lines with all columns) so that you can impose your requirements on the original material. Then we can call on Skype.
-
3439 86 1 2 Ready to complete your project on VBA Excel. In general, the task is clear. I will clarify in the course of implementation. Quality and speed of work is guaranteed.
-
1115 109 0 Good day, Evgeny, write to me to exchange Skype contacts.
I am professional in the development of VBA macros. There is experience in developing and subsequent support for large-scale projects. Your task is clear to me that you have a solution plan. I think the budget is somewhat exaggerated, the real value is 3000-4000 UAH. It may be cheaper, but you need to see the original files.
Skills and positive reviews on the development of macros are ready to confirm by a profile on another freelance exchange.
-
1977 82 2 1 I have a huge experience writing the most difficult tasks for Excel - see the reviews. If VBA isn’t enough, I’ll do it on the piton.
Current freelance projects in the category Web Programming
Development of a WebGL/Three.js scene with generation and export of 3D (snapshot) from an animated shaderObject Description:The project is a designer table shaped like a realistic, deep whirlpool (a central vortex that smoothly transitions from a wide horizontal tabletop to a thin elegant leg). Task Essence:A WebGL / Creative Coding developer is required to create an interactive 3D… Javascript and Typescript, Web Programming ∙ 27 minutes back ∙ 7 proposals |
Create a website on WP, without a builder.
357 USD
Need to create a catalog (most likely without a cart) just a product request form without using Elementor and others there should be a main page, product page, catalog, supplier catalog, and possibly a few others design and style like this… Web Programming ∙ 34 minutes back ∙ 33 proposals |
Shopify developer for sushi delivery website (Poland)We are looking for an experienced Shopify developer to implement a food delivery website (sushi) for a client from Katowice, Poland. What needs to be done: Set up the site on a ready-made Shopify template (template to be agreed upon) Menu with photos of dishes and descriptions… Web Programming ∙ 1 hour 59 minutes back ∙ 22 proposals |
Webflow developer for filling portfolio pages on the websiteA website custom-built on Webflow for a construction company needs to quickly fill project pages using one template (replace images and texts) For 2 languages Quantity - 6 pieces Ready to start asap, thank you! HTML & CSS, Web Programming ∙ 17 hours 54 minutes back ∙ 33 proposals |
LearnWorlds Administrator-ConfiguratorTask Set up the ready-made LearnWorlds platform for an elite online course. Do not develop the architecture — implement the already prepared structure manually in the admin panel. ———————— What needs to be done: Branding ⦁ Connect your domain ⦁ Upload the logo, set up… Content Management Systems, Web Programming ∙ 20 hours 59 minutes back ∙ 9 proposals |