Feb 11 2019 03:15 AM
Hi,
I basically wanted to create a general ledger report from multiple sheets in a workbook. i have these sheets:
1. Bills : In this sheets all the bills summaries from my customers i entered, these are the columns
A)DATE
B)INVOICE NUMBER
C)PARTY NAME
C)AMOUNT
2. PAYMENTS/RECEIVINGS: in this sheet i enter all the receivings from the parties whom i have already prepared bills of, columns are:
A) DATE
B)CHEQUE / CASH
C)PARTY NAME
D) AMOUNT
3. Adjustments: in this worksheet i enter adjustments if any like goods returned etc, columns are:
A)DATE
B)PARTY NAME
C)AMOUNT
NOW I WANT TO CONSOLIDATE / MERGE THE DATA FROM THE SHEETS IN A NEW SHEET IN THE FOLLOWING COLUMNS (LEDGER):
A)DATE
B)INVOICE NO.
C)PARTY NAME
D)DEBIT AMOUNT (BILLS AMOUNT)
E)CREDIT AMOUNT (RECEIVINGS)
F)DR/CR AMOUNT (ADJUSTMENTS)
G)BALANCE (OPENING BALANCE + DEBIT AMOUNT - CREDIT AMOUNT +/- DR/CR AMOUNT
PLEASE HELP!