Consolidating data from multiple worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-334218%22%20slang%3D%22en-US%22%3EConsolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334218%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20basically%20wanted%20to%20create%20a%20general%20ledger%20report%20from%20multiple%20sheets%20in%20a%20workbook.%20i%20have%20these%20sheets%3A%3C%2FP%3E%3CP%3E1.%20Bills%20%3A%20In%20this%20sheets%20all%20the%20bills%20summaries%20from%20my%20customers%20i%20entered%2C%20these%20are%20the%20columns%3C%2FP%3E%3CP%3EA)DATE%3C%2FP%3E%3CP%3EB)INVOICE%20NUMBER%3C%2FP%3E%3CP%3EC)PARTY%20NAME%3C%2FP%3E%3CP%3EC)AMOUNT%3C%2FP%3E%3CP%3E2.%20PAYMENTS%2FRECEIVINGS%3A%20in%20this%20sheet%20i%20enter%20all%20the%20receivings%20from%20the%20parties%20whom%20i%20have%20already%20prepared%20bills%20of%2C%20columns%20are%3A%3C%2FP%3E%3CP%3EA)%20DATE%3C%2FP%3E%3CP%3EB)CHEQUE%20%2F%20CASH%3C%2FP%3E%3CP%3EC)PARTY%20NAME%3C%2FP%3E%3CP%3ED)%20AMOUNT%3C%2FP%3E%3CP%3E3.%20Adjustments%3A%20in%20this%20worksheet%20i%20enter%20adjustments%20if%20any%20like%20goods%20returned%20etc%2C%20columns%20are%3A%3C%2FP%3E%3CP%3EA)DATE%3C%2FP%3E%3CP%3EB)PARTY%20NAME%3C%2FP%3E%3CP%3EC)AMOUNT%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENOW%20I%20WANT%20TO%20CONSOLIDATE%20%2F%20MERGE%20THE%20DATA%20FROM%20THE%20SHEETS%20IN%20A%20NEW%20SHEET%20IN%20THE%20FOLLOWING%20COLUMNS%20(LEDGER)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA)DATE%3C%2FP%3E%3CP%3EB)INVOICE%20NO.%3C%2FP%3E%3CP%3EC)PARTY%20NAME%3C%2FP%3E%3CP%3ED)DEBIT%20AMOUNT%20(BILLS%20AMOUNT)%3C%2FP%3E%3CP%3EE)CREDIT%20AMOUNT%20(RECEIVINGS)%3C%2FP%3E%3CP%3EF)DR%2FCR%20AMOUNT%20(ADJUSTMENTS)%3C%2FP%3E%3CP%3EG)BALANCE%20(OPENING%20BALANCE%20%2B%20DEBIT%20AMOUNT%20-%20CREDIT%20AMOUNT%20%2B%2F-%20DR%2FCR%20AMOUNT%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPLEASE%20HELP!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-334218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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!

0 Replies