Way(s) to combine varying size worksheets into one summary ?

arecube

New Member
Joined
Feb 24, 2006
Messages
46
A monthly trial balance report can be downloaded to Excel. More or less accounts may be downloaded in subsequent months. So you can have a workbook with several worksheets of different sizes (number of rows) representing each month. The first column (field) contains both an account and account description. The 5th column has the amount.

Is there a way to create one summary worksheet with all the accounts from the other monthly worksheets in column A, in account order, followed by columns of monthly Year to Date balances ? The account and description are in column A and the balance in column E.

Co.. X.. January
--------A---------B-----C------D-------E
12345..cash…..3.15..3.15…...6.30….57.66
15211..parts…..1.20..4.20..<3.00>.19.23

Co.. X.. February
--------A---------B-----C------D-------E
12345..cash…..1.15..3.15..<2.00>.…55.66
15211..parts…..0.00..0.00…0.00…....19.23
18833..receiv…5.00...3.00…2.00....105.45

Co.. X.. March
--------A---------B-----C------D-------E
10001..cash…..1.00..0.00…1.00.…..1.00
15211..parts…..0.00..0.00…0.00….19.23
18833..receiv…3.00..3.00…0.00....105.45
19999 scrap…15.00 1.00 14.00…404.06

Goal
Quarter..1……Jan…..…...Feb……...Mar….
10001..cash……0.00……0.00…..….1.00……
12345..cash…..57.66 .....56.66….......0.00
15211..parts…..19.23…..19.23….....19.23
18833..receiv….0.00….105.45……105.45
19999 scrap… 0.00…… 0.00…….404.06
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

arecube

New Member
Joined
Feb 24, 2006
Messages
46
Thanks, interesting, but not quite what I'm looking for

Thanks WSC,

What you referred me to was interesting but it wasn't quite what I'm looking for.
Arecube
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,634
Members
410,804
Latest member
bluepinky
Top