Justin
asked on
Macro which simplifies accounts
Hi Guys, I have a spread sheet with a Debit Balance column F and Credit Balance column G. I need a macro which multiplies the Debit Balance column by -1 and creates a new  column which shows the net balance between the two.
Example.xlsx
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
EXCELLENT
It doesn't make sense to use a macro for this. A simple formula and formatting the data as a Table to ensure the formula copies down is all that is necessary.
Agree with Roy, hence why I posted a formula option.
If not using a table, a simple double click on the bottom right of the cell will fill down as required.
If not using a table, a simple double click on the bottom right of the cell will fill down as required.
Formulas, etc will actually copy down automatically without a Table but a Table has other advantages.
To check this is set up go to File -> Options -> Advanced -> Editing Options
Make sure that the Extend Data Range Formulas and Formats option is checked
To check this is set up go to File -> Options -> Advanced -> Editing Options
Make sure that the Extend Data Range Formulas and Formats option is checked
Put this formula in H2 and copy down:
=I1-F2+G2
I notice that column B has currency code. Are your values in columns F and G in the currency quoted or is the value after conversion from that currency? If still in base currency, the running balance will be meaningless as you are using multiple currencies.
Thanks
Rob