Hello Ivan Hoe,


I am new to this form. I need your help in my excel project. I have a workbook with one sheets (Shee1). This sheet contains more than one thousand records (which I down load from the system every month). It also has lots of duplicate transactions but each transaction has a value in one of the columns (col. F or col. G ) or some times in both the columns against it.

My First requirement is:
1. I need to filter the Sheet1 for Unique records (records start from Col. A7 & filter criteria is the doc. ref. in
col. C).
2. Then each filtered record should add up the values from col. F or col. G against it.
3. The record should also add up the values form col. F or col. G of any duplicate transactions below.
4. Then all these unique records need to be copied to Sheet2 from Col. A7 to Col. G. (shown in the example
below).
5. The col. G of Sheet2 should show either Dr. or Cr. based on the summed up values of col. F and Col. G of
Sheet1 (Hope i am not confusing u here).
Sheet1:
A B C D E F (Dr.) G (Cr.)
7 1/1/09 1/1/09 00120 I09132 B0001 10.25 00.00
8 1/1/09 1/1/09 00120 I09133 B0001 00.00 100.00
9 1/1/09 1/1/09 00120 I09135 B0001 00.00 100.00
10 2/1/09 2/1/09 00121 I09138 B0001 20.00 100.00
11 3/1/09 3/1/09 00670 W0912 B0001 100.00 00.00

Sheet2:
A B C D E F G
7 1/1/09 1/1/09 00120 I09132 B0001 189.75 Cr <-- (summed up value of 3 transactions)
8 2/1/09 2/1/09 00121 I09138 B0001 80.00 Cr
9 3/1/09 1/1/09 00670 W0912 B0001 100.00 Dr

I have been trying work this through a macro but did not succeed. I would really appreciate if you can write a simple code in Visual Basic for me to automate this process. Hope I am not asking u too much.

thanks a lot.