Vba : Copy Paste or Export Data Between Another Sheet

[muhammad susanto]

hi all..
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

 

[muhammad susanto]

here this my link file

Meet Google Drive – One place for all your files

Google Drive is a free way to keep your files backed up and easy to reach from any phone, tablet, or computer. Start with 15GB of Google storage – free.

drive.google.com