Copy from Sheet1 to Sheet2

[Abdulkhadar]

Hello Excel Experts.
The columns in Sheet1, B6: B14, F6: F14, J6: J14, B22: B30, etc are centre code and the corresponding columns C6: C14, G6: G14, H6: H14, C22: C30, etc are number of bundles I would like to copy and paste in Sheet2 from cell B4, Q4, AE4, AQ4 etc.respectively. If number of bundle is 1 then at cell B4 of sheet2 I want 001-OO/ 1, if number of bundle is 2 then I want at cell B4 of sheet2 I want 001-OO/ 1 and at cell B5 001-OO/ 2.

Like that, The columns in Sheet1, M6:M14, Q6:Q14,U6:U14, M22:M30, etc are centre code and the corresponding columns N6:N14, R6:R14,V6:V14, N22:N30, etc are number of bundles I would like to copy and paste in Sheet2 from B23, Q23, AE23, AQ23 etc. If number of bundle is 1 then at cell B23 of sheet2 I want 001-OO/ 1, if number of bundle is 2 then I want at cell B23 of sheet2 I want 001-OO/ 1 and at cell B24 001-OO/ 2.

Thanks in advance.

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Medium1				Medium1				Medium1			Medium2				Medium2				Medium2
2
3
4	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles
5
6	01	001-OO	3		10	015-OO	1		19	032-OO	2	01	001-OO	1		10	015-OO	1		19	032-OO	1
7	02	002-OO	1		11	016-OO	1		20	033-OO	1	02	002-OO	1		11	016-OO	1		20	033-OO	1
8	03	004-OO	2		12	019-OO	1		21	034-OO	2	03	004-OO	1		12	019-OO	2		21	034-OO	1
9	04	005-OO	2		13	020-OO	2		22	037-OO	2	04	005-OO	1		13	020-OO	1		22	037-OO	1
10	05	006-OO	2		14	023-OO	1		23	038-OO	2	05	006-OO	1		14	023-OO	2		23	038-OO	0
11	06	008-OO	2		15	024-OO	2		24	040-OO	3	06	008-OO	1		15	024-OO	1		24	040-OO	1
12	07	010-OO	2		16	025-OO	2		25	042-OO	3	07	010-OO	1		16	025-OO	1		25	042-OO	1
13	08	012-OO	2		17	028-OO	1		26	043-OO	1	08	012-OO	2		17	028-OO	1		26	043-OO	1
14	09	014-OO	2		18	030-OO	1		27	044-OO	2	09	014-OO	1		18	030-OO	1		27	044-OO	1
15	Total		18		Total		12		Total		18	Total		10		Total		11		Total		8
16
17	Medium1				Medium1				Medium1			Medium2				Medium2				Medium2
18
19
20	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles
21
22	28	045-OO	1		37	059-OO	1		46	080-OO	3	28	045-OO	1		37	059-OO	1		46	080-OO	1
23	29	049-OO	1		38	060-OO	2		47	083-OO	1	29	049-OO	1		38	060-OO	1		47	083-OO	1
24	30	050-OO	1		39	061-OO	2		48	084-OO	1	30	050-OO	1		39	061-OO	1		48	084-OO	1
25	31	051-OO	2		40	064-OO	1		49	085-OO	1	31	051-OO	1		40	064-OO	1		49	085-OO	1
26	32	053-OO	1		41	066-OO	1		50	088-OO	2	32	053-OO	1		41	066-OO	1		50	088-OO	1
27	33	055-OO	2		42	075-OO	2		51	091-OO	2	33	055-OO	1		42	075-OO	0		51	091-OO	1
28	34	056-OO	2		43	077-OO	1		52	092-OO	2	34	056-OO	1		43	077-OO	1		52	092-OO	1
29	35	057-OO	2		44	078-OO	1		53	093-OO	1	35	057-OO	1		44	078-OO	1		53	093-OO	1
30	36	058-OO	2		45	079-OO	2		54	094-OO	2	36	058-OO	1		45	079-OO	1		54	094-OO	1
31	Total		14		Total		13		Total		15	Total		9		Total		8		Total		9
32
33	Medium1				Medium1				Medium1			Medium2				Medium2				Medium2
34
35
36	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles
37
38	55	096-OO	2		64	112-OO	2		73	123-OO	2	55	096-OO	1		64	112-OO	1		73	123-OO	1
39	56	098-OO	2		65	115-OO	2		74	124-OO	1	56	098-OO	1		65	115-OO	1		74	124-OO	1
40	57	099-OO	1		66	116-OO	2		75	125-OO	2	57	099-OO	1		66	116-OO	1		75	125-OO	1
41	58	100-OO	1		67	117-OO	3		76	126-OO	1	58	100-OO	2		67	117-OO	1		76	126-OO	1
42	59	105-OO	1		68	118-OO	2		77	127-OO	2	59	105-OO	1		68	118-OO	1		77	127-OO	1
43	60	106-OO	2		69	119-OO	1		78	128-OO	2	60	106-OO	1		69	119-OO	1		78	128-OO	1
44	61	107-OO	2		70	120-OO	1		79	129-OO	2	61	107-OO	1		70	120-OO	1		79	129-OO	1
45	62	108-OO	1		71	121-OO	2		80	130-OO	1	62	108-OO	1		71	121-OO	1		80	130-OO	1
46	63	111-OO	1		72	122-OO	2		81	131-OO	2	63	111-OO	1		72	122-OO	1		81	131-OO	1
47	Total		13		Total		17		Total		15	Total		10		Total		9		Total		9
48
49	Medium1				Medium1				Medium1			Medium2				Medium2				Medium2
50
51
52	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles
53
54	82	132-OO	1		91	143-OO	1		97	151-OO	1	82	132-OO	2		91	143-OO	1		97	151-OO	1
55	83	133-OO	2		92	145-OO	2		98	152-OO	2	83	133-OO	1		92	145-OO	1		98	152-OO	1
56	84	134-OO	1		93	147-OO	2		99	153-OO	2	84	134-OO	1		93	147-OO	1		99	153-OO	0
57	85	135-OO	1		94	148-OO	2		100	154-OO	1	85	135-OO	1		94	148-OO	1		100	154-OO	1
58	86	137-OO	2		95	149-OO	2		101	155-OO	1	86	137-OO	1		95	149-OO	1		101	155-OO	1
59	87	138-OO	2		96	150-OO	2		102	156-OO	1	87	138-OO	1		96	150-OO	1		102	156-OO	1
60	88	139-OO	2		97	151-OO	1		103	951-OO	2	88	139-OO	0		97	151-OO	1		103	951-OO	1
61	89	140-OO	2		98	152-OO	2		104	954-OO	2	89	140-OO	1		98	152-OO	1		104	954-OO	1
62	90	141-OO	1		99	153-OO	2		105	955-OO	1	90	141-OO	1		99	153-OO	0		105	955-OO	1
63	Total		14		Total		16		Total		13	Total		9		Total		8		Total		8
64
65	Medium1				Medium1				Medium1			Medium2				Medium2				Medium2
66
67
68	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles	Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles		Sl.No.	Centre Code	No. Of Bundles
69
70	106	956-OO	2		115	0	0		124	0	0	106	956-OO	1		115	0	0		124	0	0
71	107	0	0		116	0	0		125	0	0	107	0	0		116	0	0		125	0	0
72	108	0	0		117	0	0		126	0	0	108	0	0		117	0	0		126	0	0
73	109	0	0		118	0	0		127	0	0	109	0	0		118	0	0		127	0	0
74	110	0	0		119	0	0		128	0	0	110	0	0		119	0	0		128	0	0
75	111	0	0		120	0	0		129	0	0	111	0	0		120	0	0		129	0	0
76	112	0	0		121	0	0		130	0	0	112	0	0		121	0	0		130	0	0
77	113	0	0		122	0	0		131	0	0	113	0	0		122	0	0		131	0	0
78	114	0	0		123	0	0		132	0	0	114	0	0		123	0	0		132	0	0
79	Total		2		Total		0		Total		0	Total		1		Total		0		Total		0
Sheet1

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Scrtutinized DC Batch Numbers :															Scrtutinized DC Batch Numbers :
2	MEDIUM1		No. Packets	10	9	8	7	6	5	4	3	2	1	0	Total Scripts	MEDIUM1
3	Sl. No	Centre Code														Sl. No	Centre Code
4	01	001-OO/ 1														01	015-OO/ 1
5	02	001-OO/ 2														02	016-OO/ 1
6	03	001-OO/ 3														03	019-OO/ 1
7	04	002-OO/ 1														04	020-OO/ 1
8	05	004-OO/ 1														05	020-OO/ 2
9	06	004-OO/ 2														06	023-OO/ 1
10	07	005-OO/ 1														07	024-OO/ 1
11	08	005-OO/ 2														08	024-OO/ 2
12	09	006-OO/ 1														09	025-OO/ 1
13	10	006-OO/ 2														10	025-OO/ 2
14	11	008-OO/ 1														11	028-OO/ 1
15	12	008-OO/ 2														12	030-OO/ 1
16	13	010-OO/ 1														13
17	14	010-OO/ 2														14
18	15	012-OO/ 1														15
19	16	012-OO/ 2														16
20	17	014-OO/ 1														17
21	18	014-OO/ 2														18
22	MEDIUM2		No. Packets	10	9	8	7	6	5	4	3	2	1	0	Total Scripts	MEDIUM2
23	01	001-OO/ 1														01	015-OO/ 1
24	02	002-OO/ 1														02	016-OO/ 1
25	03	004-OO/ 1														03	019-OO/ 1
26	04	005-OO/ 1														04	019-OO/ 2
27	05	006-OO/ 1														05	020-OO/ 1
28	06	008-OO/ 1														06	023-OO/ 1
29	07	010-OO/ 1														07	023-OO/ 2
30	08	012-OO/ 1														08	024-OO/ 1
31	09	012-OO/ 2														09	025-OO/ 1
32	10	014-OO/ 1														10	028-OO/ 1
33	11															11	030-OO/ 1
34	12															12
35	13															13
36	14															14
Sheet2