Create a Libre Office macro comparing values in 2 tables
€30-250 EUR
Completed
Posted about 3 years ago
€30-250 EUR
Paid on delivery
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.
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 same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast
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