Create a Libre Office macro comparing values in 2 tables

Lengkap Disiarkan 3 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

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.

Visual Basic LibreOffice

ID Projek: #29007261

Tentang projek

5 cadangan Projek jarak jauh Aktif 3 tahun lepas

Dianugerahkan kepada:

writingapp

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

€165 EUR dalam sehari
(55 Ulasan)
5.2

5 pekerja bebas membida secara purata €159 untuk pekerjaan ini

schoudhary1553

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 Lagi

€180 EUR dalam 3 hari
(196 Ulasan)
7.8
nelumindralal

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 dalam 7 hari
(17 Ulasan)
4.7
buildorbust

hi..........................................................................................................................

€50 EUR dalam 3 hari
(2 Ulasan)
3.4