Home

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
hussain_51-52
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!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies