777

Budget: 100 EUR Deadline: 4 days

Good day.

The task is clear. It is necessary to automatically match the supplier's price list and the file from Bitrix by articles and visually show the positions that are not present in the availability file. The macro can be made to work with two separate files, correctly comparing articles regardless of the order of the rows and immediately highlighting the missing positions in the required file.

It is also important to include the possibility of rerunning the macro without manually clearing the results, so that it can be conveniently used on a regular basis.

Budget: 200 EUR Deadline: 4 days

Hello! I have reviewed your assignment and believe that I can successfully complete it. I would be happy to collaborate, please write to me personally for further details.

Budget: 50 EUR Deadline: 2 days

Good. I have extensive experience as a Bitrix programmer as well as writing macros and scripts for Excel... It can be done from the Excel side, or it can be done from the Bitrix side - when the script, on the server, will analyze the price and create a file with those products that are not on the site, or, in general, add missing products to the site...

Budget: 70 EUR Deadline: 2 days

Good day!

The task is clear.
I will create a macro for Excel that compares two files by article number:

supplier file (original article numbers),

Bitrix export file.

The macro will identify the article numbers that are missing from the Bitrix export and will visually highlight them in the supplier file (for example, in red).

Solution:

without manual actions,

works on any updated files,

can be expanded (report, separate sheet with the list of missing article numbers).

Before starting, I will clarify:

in which columns the article numbers are located,

if there are headers,

if additional checks are needed (duplicates, empty values).

I am ready to create and test it on your files. Expand

Budget: 30 EUR Deadline: 1 day

Good afternoon.

Yes, no problem — I can do this.

The macro will compare the "Supplier Price" file with the export from Bitrix based on the original articles and will show which articles are missing in the Bitrix file — for example, it will highlight the corresponding cells/rows in the supplier's file in red. If necessary, I can also add a separate sheet with a report (list of missing articles).

To do everything correctly, please send:

an example of the supplier price file

the export from Bitrix regarding availability

which columns contain "Article" in both files (or it is sufficient for the header to have "Article / SKU / Code").

After receiving the files, I will prepare a macro that can be run in Excel with one click. Expand

Budget: 50 EUR Deadline: 2 days

Hello!
I am ready to complete the task of creating a macro for Excel.

I have experience working with VBA and automating spreadsheets: consolidating data from different sources, comparing items, highlighting discrepancies, reports on missing items. I understand the logic of working with supplier price lists and exports from Bitrix.

I can:

correctly consolidate two files;

identify missing items;

highlight them in color or move them to a separate sheet;

if necessary, adjust to your data format.

Deadline - quickly (within a day, after reviewing the files).
I am ready to start immediately. Expand

Budget: 30 EUR Deadline: 2 days

I can do it without using a macro, just with formulas and filling in Excel. If a macro is needed, the task can also be implemented through it.

Budget: 200 EUR Deadline: 5 days

Good day, Sergey!

I will propose an effective solution for merging your file from Bitrix and the supplier's price list. I specialize in developing complex macros in Excel, which allows me to adapt algorithms to your specific needs. Your items will be identified with maximum accuracy, and missing positions will be carefully highlighted for quick analysis. Based on my experience in automating business processes and data processing, I am confident that I will quickly make a visible contribution to solving your task. I would be happy to discuss the details!