Create a Libre Office macro comparing values in 2 tables

I have two programs out of which I export different data in the form of ods files and I need to compare some of the data in the tables.

First I need to convert some of the data.

In file A in colmn B there is either an S or an H

If there is an S in column B then the value in column A should be multiplied with -1

IF B=“S“ then A=A*(-1)

In file B in column G my program exports negative values with a ' in front of the value

This needs to be removed

so '-38,81 -> -38,81 '-61,74 -> -61,74 and so on

In file B the colums F and H have corrosponding values to columns K and G in file A.

I uploaded pictures of three examples. I highlighted them with colors so that you can see them better.

As you can see, column F in file B corrosponds to column K in file A, column G in file B to column A in file A and column H in file B to column G in file A.

The purpose of the macro is to compare the values in columns G in file B and column A in file A.

Now comes the tricky part.

As you can see with the light green example in file A sometimes the values are split between different rows. Row 9 in file B corrosponds with rows 7 and 8 in file A,

In this example 545,64 in file B = 483+62,64 in file A.

So your macro needs to find the correct pairs and match them and compare the values in columns G and A. I think a good solution would be that your macro makes the rows in the colums where the values are the same light green and the rows where they aren't the same light red.

Taidot: Visual Basic, LibreOffice

Näytä lisää: excel macro comparing cells, create appointment email macro parse, excel macro cut values, create multiple choice quiz using php mysql tables, create online office, create tests office, cells empty dont create file excel macro, run office macro, macro increment values column, script create excel 2007 macro, excel create data input macro, open office macro convert linux, macro comparing rows excel, create excel word macro, create script excel macro examples insert, create website office, create users exel macro, office macro java, open office macro excel, create simple print macro excel

Tietoa työnantajasta:
( 1 arvostelu ) Stuttgart, Germany

Projektin tunnus: #29007261

Myönnetty käyttäjälle:


Hi. I have written many automation Libre Office macros. Ready to write your project. Will complete within 1 day

€165 EUR 1 päivässä
(55 Arvostelua)

5 freelanceria on tarjonnut keskimäärin €159 tähän työhön


Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa Lisää

€180 EUR 3 päivässä
(196 arvostelua)

(158 arvostelua)

Hello Sir, I went thru the description and the attached images Contact me and I will start it RIGHT NOW I look forward to hearing from you Thanks regards Thushara

€200 EUR 7 päivässä
(17 arvostelua)


€50 EUR 3 päivässä
(2 arvostelua)