User will use worksheet similar to below:--- Users are allowed to enter data manually into all 6 columns(BATCH_NAME,CUR_CODE,DEPT,ACCOUNT,DEBIT,CRE DIT)

BATCH_NAME| CUR_CODE| DEPT ACCOUNT| DEBIT |CREDIT| Tot-DR|Tot-CR
--------- | |
BATCH-1 | USD 0171 1920 10.00 10.00 50.00 15.00
BATCH-1 | USD 0181 0010 5.00 5.00
BATCH-1 | STAT 0185 1950 15
BATCH-1 | USD 0191 1960 20.00 20.00

BATCH 2 USD 8855 5522 30.00 30.00 110.0 50.00
BATCH 2 USD 8855 5522 20.00 20.00
BATCH 2 STAT 6685 8999 60.00
BATCh3 STAT
BATCh4 USD
Etc....

REQUIREMENTS:

Now I like to show user Total amount of All the same type of Batch-Name (DEBIT, CREDIT) amount under Tot-DR and Total-CR column
All the same batch (BATCH-1 and BATCH 2)Kind of Filter/Group-by same batch.

Another word for first batch wich is BATCH-1 (First 4 entries) total sum will be 50.00 and 15.00
Batch 2 will be 110.00 and 50.00.

If we can do this in programmatically using some kind of Command button/macro to compute those will be a great. User could have as many as 5 to 10 different batches and each batch has as many as 10 to 15 line items.

Any other thought will be greatly appreciated.
Thanks
Tony