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?