• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I have a trial balance below - I want debits and credits in one column please help me write macro

dee3925

New Member
TypeTypeBatchAccountAccount DescriptionPostYearRefDateSubaccountSubaccount DescriptionTransaction DescriptionDebit AmountCredit Amount
APZC035621103000REGULAR CHECKING ACCOUNT2018102018801116
43600​
NAD0X0U0006ADMIN ALLOCATION FUNDFORMO FORD CREDIT
0.00​
0.00​
APZC035620103000REGULAR CHECKING ACCOUNT2018102018801115
43600​
NAD0X0U0006ADMIN ALLOCATION FUNDFORMO FORD CREDIT
0.00​
0.00​
APZC035619103000REGULAR CHECKING ACCOUNT2018102018801114
43600​
NAD0X0U0006ADMIN ALLOCATION FUNDFORMO FORD CREDIT
0.00​
0.00​
APEP035499103000REGULAR CHECKING ACCOUNT2018102018915180
43581​
N0000000000ADMINISTRATIVEBACLO B.A.C. LOCAL #1
0.00​
4,541.04​
APEP035499103000REGULAR CHECKING ACCOUNT2018102018915181
43581​
N0000000000ADMINISTRATIVEIUPAT I.U.P.A.T D.C.21 BENEFI
0.00​
2,367.01​
APEP035499103000REGULAR CHECKING ACCOUNT2018102018915182
43581​
N0000000000ADMINISTRATIVEIUPAT I.U.P.A.T D.C.21 BENEFI
0.00​
9,134.27​
 
What do you want your result to look like? You should upload a sample workbook. We cannot manipulate pictures of data for testing.
 
Thank you ! If you could possibly show me how to write the macro and save it as a file I would be SOOOO grateful - I am not
a ninja!
 
attached is the before and what I would like the after to look like. Would like to write a macro that I can save as a file so I can
do this month after month. THANK YOU ALL SOO much.
 
Back
Top