L2VB
08-26-2019, 02:31 AM
Hello,
I seek your help because I would like to automate a tedious task on one of my excel databases.
I am still a beginner with VBA, so I don't really know how to do what I want, this is why I'm asking you guys for help.
In my database I have information about loans, and what I want to do is copy every line while inverting the account number and changing the sign of the amount.
For example I have:
Account Amount Currency
AB23 JFK5 EUR 50 000 Euro
I would want to have:
Account Amount Currency
AB23 JFK5 EUR 50 000 Euro
JFK5 AB23 EUR -50 000 Euro
Basically I want to add a line with the exact same information for everything, except for the account number which is inverted (from AB23 JFK5 EUR to JFK5 AB23 EUR) and the amount which changes sign (from 50 000 to - 50 000).
Thank you so much, I really appreciate your help.
I seek your help because I would like to automate a tedious task on one of my excel databases.
I am still a beginner with VBA, so I don't really know how to do what I want, this is why I'm asking you guys for help.
In my database I have information about loans, and what I want to do is copy every line while inverting the account number and changing the sign of the amount.
For example I have:
Account Amount Currency
AB23 JFK5 EUR 50 000 Euro
I would want to have:
Account Amount Currency
AB23 JFK5 EUR 50 000 Euro
JFK5 AB23 EUR -50 000 Euro
Basically I want to add a line with the exact same information for everything, except for the account number which is inverted (from AB23 JFK5 EUR to JFK5 AB23 EUR) and the amount which changes sign (from 50 000 to - 50 000).
Thank you so much, I really appreciate your help.