Hi
I want showing the lastrow for each name from sheet to another based on column C in sheet filter with ignore columns A,B,D
sheet filter
the result in sheet OUTPUT from row2 with the same borders & formatting . with considering any changing or adding new data in sheet filter should update in sheet output .
thanks
I want showing the lastrow for each name from sheet to another based on column C in sheet filter with ignore columns A,B,D
sheet filter
f .xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | DATE | INVOICE NO | CLIENT NO | DESCRIBE | DEBIT | CREDIT | BALANCE | ||
2 | 1/1/2022 | - | ABDEND1 | OPENNING | 20,000.00 | - | 20,000.00 | ||
3 | 1/4/2022 | PA-B3 | ABDEND1 | PA | 20,000.00 | - | 40,000.00 | ||
4 | 1/5/2022 | SA-B35 | ABDEND1 | SA | - | 1,000.00 | 39,000.00 | ||
5 | 1/2/2022 | PA-B36 | ABDEND2 | PA | 1,000.00 | - | 1,000.00 | ||
6 | 1/7/2022 | PA-B37 | ABDEND2 | PA | 1,000.00 | - | 2,000.00 | ||
7 | 1/13/2022 | PA-B45 | ABDEND2 | PA | 1,000.00 | 100.00 | 2,900.00 | ||
8 | 1/3/2022 | PA-B38 | ABDEND3 | openning | - | 200.00 | -200.00 | ||
9 | 1/6/2022 | PA-B39 | ABDEND3 | PA | 5,000.00 | - | 4,800.00 | ||
10 | 1/8/2022 | PA-B40 | ABDEND3 | PA | 5,000.00 | - | 9,800.00 | ||
11 | 1/9/2022 | PA-B41 | ABDEND3 | PA | 5,000.00 | - | 14,800.00 | ||
12 | 1/10/2022 | PA-B42 | ABDEND3 | PA | 2,000.00 | - | 16,800.00 | ||
13 | 1/11/2022 | PA-B43 | ABDEND3 | PA | 1,000.00 | 100.00 | 17,700.00 | ||
14 | 1/12/2022 | PA-B44 | ABDEND4 | PA | 1,000.00 | 100.00 | 900.00 | ||
filter |
the result in sheet OUTPUT from row2 with the same borders & formatting . with considering any changing or adding new data in sheet filter should update in sheet output .
f.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | CLIENT NO | DEBIT | CREDIT | BALANCE | ||
2 | 1 | ABDEND1 | - | 1,000.00 | 39,000.00 | ||
3 | 2 | ABDEND2 | 1,000.00 | 100.00 | 2,900.00 | ||
4 | 3 | ABDEND3 | 1,000.00 | 100.00 | 17,700.00 | ||
5 | 4 | ABDEND4 | 1,000.00 | 100.00 | 900.00 | ||
output |
thanks