muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,102
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have table like this
input
how to make easy using macro or vba
note:
1. copy from sheet "input" to "data capaian"
2. series number as clue (unique key)
3. destination target column F till H down based on series and name
4. please, don't change column or rows
5. if it's possible, i hope the code only work in visible cell
any body help, greatly appreciated.
.sst
i have table like this
copy data vba.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
7 | Clue | Descriptiom | Target 2021 | Q1 | Q2 | |||||
10 | (1) | (2) | (3) | (4) | (5) | (6) | (7) | |||
11 | 1 | - | Pengelolaan kekayaan negara dan lelang yang optimal | |||||||
12 | 1a-CP | P/M | Tingkat Kesesuaian Penggunaan BMN dengan SBSK | MAX/TLK | ||||||
13 | Target tingkat kesesuaian Penggunaan BMN dengan SBSK | 62% | 65% | |||||||
14 | 65% | |||||||||
15 | Monev KPKNL | |||||||||
16 | 1 | JOHN | 10% | 3% | 5% | |||||
17 | 2 | MIKE | 20% | 15% | 9% | |||||
18 | 3 | BRYAN | 15% | 12% | 8% | |||||
19 | 4 | SISCA | 5% | 4% | 5% | |||||
20 | 5 | IRFAN | 10% | 5% | 5% | |||||
21 | 6 | ZIDAN | 23% | 14% | 12% | |||||
22 | Capaian IKU | |||||||||
23 | 1b-CP | P/M | Persentase Penerimaan Negara dari Pengelolaan Kekayaan Negara dan Lelang | MAX/TLK | ||||||
24 | a. | Target/Realisasi PNBP BMN | Rp 14.300 | #VALUE! | #VALUE! | |||||
25 | 7 | JOHN | 1.000 | etc… | etc.. | |||||
26 | 8 | MIKE | 1.500 | |||||||
27 | 9 | BRYAN | 2.000 | |||||||
28 | 10 | SISCA | 3.000 | |||||||
29 | 11 | IRFAN | 4.500 | |||||||
30 | 12 | ZIDAN | 2.300 | |||||||
Data Capaian |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F24:H24 | F24 | =SUM(F25+F26+F27+F28+F29+F30+F32) |
input
copy data vba.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Clue | name | Target 2021 | Q1 | Q2 | ||
2 | 1 | JOHN | 10% | 3% | 5% | ||
3 | 2 | MIKE | 20% | 15% | 9% | ||
4 | 3 | BRYAN | 15% | 12% | 8% | ||
5 | 4 | SISCA | 5% | 4% | 5% | ||
6 | 5 | IRFAN | 10% | 5% | 5% | ||
7 | 6 | ZIDAN | 23% | 14% | 12% | ||
8 | 7 | JOHN | 1000 | 800 | 5000 | ||
9 | 8 | MIKE | 1500 | 800 | 6900 | ||
10 | 9 | BRYAN | 2000 | 200 | 999 | ||
11 | 10 | SISCA | 3000 | 800 | 777 | ||
12 | 11 | IRFAN | 4500 | 800 | 777 | ||
13 | 12 | ZIDAN | 2300 | 800 | 777 | ||
input |
how to make easy using macro or vba
note:
1. copy from sheet "input" to "data capaian"
2. series number as clue (unique key)
3. destination target column F till H down based on series and name
4. please, don't change column or rows
5. if it's possible, i hope the code only work in visible cell
any body help, greatly appreciated.
.sst
Last edited: