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

Abdulkhadar

Board Regular
Joined
Nov 10, 2013
Messages
143
Office Version
  1. 2010
Platform
  1. Windows
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
ABC
1Sl. NoCentre CodeNo. of Bags
201001-OO3
302002-OO1
403004-OO2
504005-OO2
605006-OO2
706008-OO2
807010-OO2
908012-OO2
1009014-OO2
1110015-OO1
1211016-OO1
1312019-OO1
1413020-OO2
1514023-OO1
1615024-OO2
1716025-OO2
1817028-OO1
1918030-OO1
2019032-OO2
2120033-OO1
2221034-OO2
2322037-OO2
2423038-OO2
2524040-OO3
2625042-OO3
2726043-OO1
2827044-OO2
2928045-OO1
3029049-OO1
3130050-OO1
3231051-OO2
3332053-OO1
3433055-OO2
3534056-OO2
3635057-OO2
3736058-OO2
3837059-OO1
3938060-OO2
4039061-OO2
4140064-OO1
4241066-OO1
4342075-OO2
4443077-OO1
4544078-OO1
4645079-OO2
4746080-OO3
4847083-OO1
4948084-OO1
5049085-OO1
5150088-OO2
5251091-OO2
5352092-OO2
5453093-OO1
5554094-OO2
5655096-OO2
5756098-OO2
5857099-OO1
5958100-OO1
6059105-OO1
6160106-OO2
6261107-OO2
6362108-OO1
6463111-OO1
6564112-OO2
6665115-OO2
6766116-OO2
6867117-OO3
6968118-OO2
7069119-OO1
7170120-OO1
7271121-OO2
7372122-OO2
7473123-OO2
7574124-OO1
7675125-OO2
7776126-OO1
7877127-OO2
7978128-OO2
8079129-OO2
8180130-OO1
8281131-OO2
8382132-OO1
8483133-OO2
8584134-OO1
8685135-OO1
8786137-OO2
8887138-OO2
8988139-OO2
9089140-OO2
9190141-OO1
9291143-OO1
9392145-OO2
9493147-OO2
9594148-OO2
9695149-OO2
9796150-OO2
9897151-OO1
9998152-OO2
10099153-OO2
101100154-OO1
102101155-OO1
103102156-OO1
104103951-OO2
105104954-OO2
106105955-OO1
107106956-OO2
Sheet1


Book3.xlsm
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBH
1Scrtutinized DC Batch Numbers : Scrtutinized DC Batch Numbers : Scrtutinized DC Batch Numbers : Scrtutinized DC Batch Numbers :
2MEDIUM1No. Packets109876543210Total ScriptsMEDIUM1No. Packets109876543210Total ScriptsMEDIUM1No. Packets109876543210Total ScriptsMEDIUM1No. Packets109876543210Total Scripts
3Sl. NoCentre CodeSl. NoCentre CodeSl. NoCentre CodeSl. NoCentre Code
401001-OO/ 101015-OO/ 101032-OO/ 101045-OO/ 1
502001-OO/ 202016-OO/ 102032-OO/ 202049-OO/ 1
603001-OO/ 303019-OO/ 103033-OO/ 103050-OO/ 1
704002-OO/ 104020-OO/ 104034-OO/ 104051-OO/ 1
805004-OO/ 105020-OO/ 205034-OO/ 205051-OO/ 2
906004-OO/ 206023-OO/ 106037-OO/ 106053-OO/ 1
1007005-OO/ 107024-OO/ 107037-OO/ 207055-OO/ 1
1108005-OO/ 208024-OO/ 208038-OO/ 108055-OO/ 2
1209006-OO/ 109025-OO/ 109038-OO/ 209056-OO/ 1
1310006-OO/ 210025-OO/ 210040-OO/ 110056-OO/ 2
1411008-OO/ 111028-OO/ 111040-OO/ 211057-OO/ 1
1512008-OO/ 212030-OO/ 112040-OO/ 312057-OO/ 2
1613010-OO/ 113042-OO/ 113058-OO/ 1
1714010-OO/ 214042-OO/ 214058-OO/ 2
1815012-OO/ 115042-OO/ 3
1916012-OO/ 216043-OO/ 1
2017014-OO/ 117044-OO/ 1
2118014-OO/ 218044-OO/ 2
Sheet2
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,127,450
Messages
5,624,831
Members
416,058
Latest member
SEJTurner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top