Hello
I want creating report in OUTPUT sheet .
it should populate names and sum amounts in DEBIT column and CREDIT column for each duplicates names
and insert TOTAL row to sum whole columns DEBIT,CREDIT . every time I will add new data in ALL sheet so should clear data before brings in OUPUT sheet
the names will be in last location in item .
the data could be 5000 rows
before
result
I want creating report in OUTPUT sheet .
it should populate names and sum amounts in DEBIT column and CREDIT column for each duplicates names
and insert TOTAL row to sum whole columns DEBIT,CREDIT . every time I will add new data in ALL sheet so should clear data before brings in OUPUT sheet
the names will be in last location in item .
the data could be 5000 rows
OMRAN.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | DATE | DESCRIBE | DEBIT | CREDIT | ||
2 | 01/01/2023 | SALES INVOICE AT300 - OMRAN OMAR | 3,000.00 | |||
3 | 02/01/2023 | SALES INVOICE AT301 - OMAR ALI | 6,000.00 | |||
4 | 03/01/2023 | SALES INVOICE AT302 - ALI OMARN | 10,000.00 | |||
5 | 04/01/2023 | PAID OMRAN OMAR | 1,000.00 | |||
6 | 05/01/2023 | PAID ALI OMARN | 2,000.00 | |||
7 | 06/01/2023 | SALES INVOICE AT303 - OMRAN OMAR | 3,000.00 | |||
8 | 07/01/2023 | SALES INVOICE AT304 - ALI OMARN | 50,000.00 | |||
9 | 08/01/2023 | PAID OMRAN OMAR | 1,200.00 | |||
10 | 09/01/2023 | PAID OMRAN OMAR | 200.00 | |||
all |
before
OMRAN.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | NAME | DEBIT | CREDIT | BALANCE | ||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
OUTPUT |
result
OMRAN.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | NAME | DEBIT | CREDIT | BALANCE | ||
2 | 1 | OMRAN OMAR | 6,000.00 | 2,400.00 | 3,600.00 | ||
3 | 2 | OMAR ALI | 6,000.00 | 0.00 | 6,000.00 | ||
4 | 3 | ALI OMARN | 60,000.00 | 2000 | 58,000.00 | ||
5 | TOTAL | 72,000.00 | 4,400.00 | 67,600.00 | |||
OUTPUT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E5 | E2 | =C2-D2 |
C5:D5 | C5 | =SUM(C2:C4) |