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

#### arecube

##### New Member
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

### 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
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

Replies
0
Views
191
Replies
12
Views
416