Hey all,

I have 1,300 rows of G/L data that I need to clean up each month to create a
Staement of Cash Flows. The data is in five columns.

A B C D
E
G/L# Branch# Description Current Month Pior Month
701000 0 XXXX 12
10
701000 1 XXXX 10
11
701000 2 XXXX 5
10
701001 0 YYYY 6
5
701001 1 YYYY 2
3
701001 2 YYYY 1
3


I would like to write a macro that will sum the current and prior month
balances by G/L# and copy the G/L#, Description, and Totals to a new sheet.
Can someone help me start this?

you can do this with Data=Subtotals

Sum Current Month and Prior Month on G/L#

go to column C and do
Edit=goto=Special and select blanks

assume the first cell selected (the active cell) is C4. go to the formula
bar and enter

=C3 then do Ctrl+Enter

Use the cell address above the activecell.

This will fill in the descriptions in the subtotal rows

now select all of column 3 (column C) and do Edit=Copy, then do
Edit=PasteSpecial and select Values.

Now click on the little button on the top left with a 2 on it. This will
show the subtotals by G/L

select all you data and do Edit=Go=Special and select visible. Then do
edit = copy, go to you new sheet, select A1 and do Edit =Paste.

If you want a macro, you can turn on the macro recorder while you do it
manually, then generalize the code.

You can also look do something similar by using a Pivot table. select your
data, then do Data=Pivot Table, designate the source of your data, go to
the next dialog, select Layout, put G/L in the row field, leave the column
field blank, and put Current Month and Prior Month in the data area.

Click OK, make sure the destination is a new sheet, then click OK.

Now go to the Databutton and drag if slightly to the right and let it go.
This will put Current Month and Prior Month next to each other rather than
on top of each other.

--
Regards,
Tom Ogilvyi

"cwilson" wrote in message
...
Hey all,

I have 1,300 rows of G/L data that I need to clean up each month to create
a
Staement of Cash Flows. The data is in five columns.

A B C D
E
G/L# Branch# Description Current Month Pior Month
701000 0 XXXX 12
10
701000 1 XXXX 10
11
701000 2 XXXX 5
10
701001 0 YYYY 6
5
701001 1 YYYY 2
3
701001 2 YYYY 1
3


I would like to write a macro that will sum the current and prior month
balances by G/L# and copy the G/L#, Description, and Totals to a new
sheet.
Can someone help me start this?