I am using multiple charts to display different items of Liabilities and Assets. E.g. "DEPOSIT FROM INDIVIDUAL" is one of the liability head and "CASH & BANK BALANCES" is one of the asset head. I am using one chart to display all GLName and Amount for Name = "DEPOSIT FROM INDIVIDUAL" and another chart for Name = "CASH & BANK BALANCES". I am using a macro in VBScript to achieve the output in text file. The required text format and the macro code I am using is attached below:
I want to display "DEPOSIT FROM INDIVIDUAL" to extreme left and "CASH & BANK BALANCES" on right side. This format is attached.
Please let me know how can I achieve the desired output using macro.
