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.
5 pekerja bebas membida secara purata €159 untuk pekerjaan ini
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