Copy & paste from Sheet1 to Sheet2 at every 9 intervals as per condition

[Abdulkhadar]

Hello Excel Experts,

In Sheet1, column B2 centre code and column C2 Number of Bags, I would like to copy and paste in Sheet2 from cell B4, Q4, AE4, AQ4 etc., respectively at every 9 centres according to number of bags. If number of bag/s is 1 then at cell B4 of sheet2 I want as 001-OO/ 1, if number of bag/s are 2 then I want at cell B4 of sheet2 I want 001-OO/ 1 and at cell B5 001-OO/ 2. Like that after 9th centre the 10th centre is 015-OO and the number of bags is 1 then, i want to copy and paster as 018-00/1 at Q4. Like that....
Thanks in advance

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

Book3.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH
1	Scrtutinized DC Batch Numbers :															Scrtutinized DC Batch Numbers :															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		No. Packets	10	9	8	7	6	5	4	3	2	1	0	Total Scripts	MEDIUM1		No. Packets	10	9	8	7	6	5	4	3	2	1	0	Total Scripts	MEDIUM1		No. Packets	10	9	8	7	6	5	4	3	2	1	0	Total Scripts
3	Sl. No	Centre Code														Sl. No	Centre Code														Sl. No	Centre Code														Sl. No	Centre Code
4	01	001-OO/ 1														01	015-OO/ 1														01	032-OO/ 1														01	045-OO/ 1
5	02	001-OO/ 2														02	016-OO/ 1														02	032-OO/ 2														02	049-OO/ 1
6	03	001-OO/ 3														03	019-OO/ 1														03	033-OO/ 1														03	050-OO/ 1
7	04	002-OO/ 1														04	020-OO/ 1														04	034-OO/ 1														04	051-OO/ 1
8	05	004-OO/ 1														05	020-OO/ 2														05	034-OO/ 2														05	051-OO/ 2
9	06	004-OO/ 2														06	023-OO/ 1														06	037-OO/ 1														06	053-OO/ 1
10	07	005-OO/ 1														07	024-OO/ 1														07	037-OO/ 2														07	055-OO/ 1
11	08	005-OO/ 2														08	024-OO/ 2														08	038-OO/ 1														08	055-OO/ 2
12	09	006-OO/ 1														09	025-OO/ 1														09	038-OO/ 2														09	056-OO/ 1
13	10	006-OO/ 2														10	025-OO/ 2														10	040-OO/ 1														10	056-OO/ 2
14	11	008-OO/ 1														11	028-OO/ 1														11	040-OO/ 2														11	057-OO/ 1
15	12	008-OO/ 2														12	030-OO/ 1														12	040-OO/ 3														12	057-OO/ 2
16	13	010-OO/ 1																													13	042-OO/ 1														13	058-OO/ 1
17	14	010-OO/ 2																													14	042-OO/ 2														14	058-OO/ 2
18	15	012-OO/ 1																													15	042-OO/ 3
19	16	012-OO/ 2																													16	043-OO/ 1
20	17	014-OO/ 1																													17	044-OO/ 1
21	18	014-OO/ 2																													18	044-OO/ 2
Sheet2