Fix My Libre Office Macro

$ 50.00 — 60.00 USD
My macro doesn't give me the correct values.
The first three steps work, but not step No. 4.
The orignal programmer does not know how to fix this.
Perhaps this only requires a minor tweek.
I posted the original posting again in it's entirety, but only step No. 4 which is the most tricky one needs to be fixed.

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.

1) 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)

2) 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

3) 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.

4) 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.

Similar Freelance jobs:

Assessoria E Consultoria Em Vba/excel/access E Banco De Dados
Necessito de consultoria/assessoramento para criação de projetos em VBA/Excel/ACCESS. a ideia é que eu faça  alguns projetos e/ou acompanhe profissional com mais experiência para adquirir mais conhecimento prático.Valores serão negociados.
Full Description of Assessoria e Consultoria em VBA/EXCEL/ACCESS e Banco de…
Create Proposal Software Or Excel To Word Integraton
We are an energy and solar company who do solar financial modelling for businesses. We currently manually create excel spreadsheets, which we then copy and paste into our proposal templates. We have to then manually write customer details, company name etc. So this is a slow process. We are looking at 2 options 1. Full company software, where you login input the system size, customer details and it will generate a proposal. 2. Simple excel to word integration. If we…
Full Description of Create proposal software or excel to word integraton
Excel Task
Column A includes existing members, and column B includes new members that have been referred by members from column A. Column A has many duplicated names. I basically need to find all duplicated members in column A and put all the names they referred next to them in column B, C, D, E. I can explain more through live chat.
Full Description of Excel Task
Excel Simulation Of Process To Be Prepared For Building The Application And Easy Understanding
Excel simulation is to be prepared for the process to automate the business process based of Scope of work document which consist of pointers / one liners of requirement and can be easily visuailzed by the experienced professionals who may have experience of ERP/CRM etc.
Full Description of Excel simulation of process to be prepared for…
Excel Expert
I have some works in excel spread sheet for students attendance sheet.
Full Description of Excel Expert
Looking For Excel Vba Expert/developer
From a outpatient pharmacy that does dispensing medication transaction daily. Hence, looking for a excel VBA tool that can record each patients given/dispensed medication record. And that keep up the record for inventory.
Full Description of Looking for excel vba expert/developer
Visual Studio Expert Help
Hi i want to customize visual studio 2019 project this code https://codecanyon.net/item/wowonder-android-messenger-mobile-application-for-wowonder/19034167 https://codecanyon.net/item/wowonder-the-ultimate-php-social-network-platform/13785302 who can done with in 7 days Thanks
Full Description of Visual Studio Expert Help
Excel Spreadsheet Needed For Golf Scoring
I have attached a spreadsheet that I need to have finished. Please take a look. I can answer any questions you may have. $40 dollars is the set price.
Full Description of Excel Spreadsheet Needed for Golf Scoring
Vba-xlm File Improvement.
I need to improve a VBA program in excel. Someone already developed the macro but I need to fix some issues with it. This macro is used to find the amount of pipes needed to cover a certain area. However I need this to program to give the optimum arrangement of pipes to cover the area.
Full Description of VBA-XLM file improvement.
© 2006 — 2024 hirelancer.com is an affiliate website, listing the freelance projects. We are collaborating with other sites like getFreelancer.com. Feel free to bid on any project and good luck! You will need register first, before bidding or posting projects. Basic memberhsip is always free. We might earn commissions from referring you. You will never ever pay additional fees for we referred you.