Copy from Sheet1 to Sheet2

Abdulkhadar

Board Regular
Joined
Nov 10, 2013
Messages
165
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
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
ABCDEFGHIJKLMNOPQRSTUV
1Medium1Medium1Medium1Medium2Medium2Medium2
2
3
4Sl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of Bundles
5
601001-OO310015-OO119032-OO201001-OO110015-OO119032-OO1
702002-OO111016-OO120033-OO102002-OO111016-OO120033-OO1
803004-OO212019-OO121034-OO203004-OO112019-OO221034-OO1
904005-OO213020-OO222037-OO204005-OO113020-OO122037-OO1
1005006-OO214023-OO123038-OO205006-OO114023-OO223038-OO0
1106008-OO215024-OO224040-OO306008-OO115024-OO124040-OO1
1207010-OO216025-OO225042-OO307010-OO116025-OO125042-OO1
1308012-OO217028-OO126043-OO108012-OO217028-OO126043-OO1
1409014-OO218030-OO127044-OO209014-OO118030-OO127044-OO1
15Total18Total12Total18Total10Total11Total8
16
17Medium1Medium1Medium1Medium2Medium2Medium2
18
19
20Sl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of Bundles
21
2228045-OO137059-OO146080-OO328045-OO137059-OO146080-OO1
2329049-OO138060-OO247083-OO129049-OO138060-OO147083-OO1
2430050-OO139061-OO248084-OO130050-OO139061-OO148084-OO1
2531051-OO240064-OO149085-OO131051-OO140064-OO149085-OO1
2632053-OO141066-OO150088-OO232053-OO141066-OO150088-OO1
2733055-OO242075-OO251091-OO233055-OO142075-OO051091-OO1
2834056-OO243077-OO152092-OO234056-OO143077-OO152092-OO1
2935057-OO244078-OO153093-OO135057-OO144078-OO153093-OO1
3036058-OO245079-OO254094-OO236058-OO145079-OO154094-OO1
31Total14Total13Total15Total9Total8Total9
32
33Medium1Medium1Medium1Medium2Medium2Medium2
34
35
36Sl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of Bundles
37
3855096-OO264112-OO273123-OO255096-OO164112-OO173123-OO1
3956098-OO265115-OO274124-OO156098-OO165115-OO174124-OO1
4057099-OO166116-OO275125-OO257099-OO166116-OO175125-OO1
4158100-OO167117-OO376126-OO158100-OO267117-OO176126-OO1
4259105-OO168118-OO277127-OO259105-OO168118-OO177127-OO1
4360106-OO269119-OO178128-OO260106-OO169119-OO178128-OO1
4461107-OO270120-OO179129-OO261107-OO170120-OO179129-OO1
4562108-OO171121-OO280130-OO162108-OO171121-OO180130-OO1
4663111-OO172122-OO281131-OO263111-OO172122-OO181131-OO1
47Total13Total17Total15Total10Total9Total9
48
49Medium1Medium1Medium1Medium2Medium2Medium2
50
51
52Sl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of Bundles
53
5482132-OO191143-OO197151-OO182132-OO291143-OO197151-OO1
5583133-OO292145-OO298152-OO283133-OO192145-OO198152-OO1
5684134-OO193147-OO299153-OO284134-OO193147-OO199153-OO0
5785135-OO194148-OO2100154-OO185135-OO194148-OO1100154-OO1
5886137-OO295149-OO2101155-OO186137-OO195149-OO1101155-OO1
5987138-OO296150-OO2102156-OO187138-OO196150-OO1102156-OO1
6088139-OO297151-OO1103951-OO288139-OO097151-OO1103951-OO1
6189140-OO298152-OO2104954-OO289140-OO198152-OO1104954-OO1
6290141-OO199153-OO2105955-OO190141-OO199153-OO0105955-OO1
63Total14Total16Total13Total9Total8Total8
64
65Medium1Medium1Medium1Medium2Medium2Medium2
66
67
68Sl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of BundlesSl.No.Centre CodeNo. Of Bundles
69
70106956-OO21150012400106956-OO11150012400
71107001160012500107001160012500
72108001170012600108001170012600
73109001180012700109001180012700
74110001190012800110001190012800
75111001200012900111001200012900
76112001210013000112001210013000
77113001220013100113001220013100
78114001230013200114001230013200
79Total2Total0Total0Total1Total0Total0
Sheet1


Book1.xlsm
ABCDEFGHIJKLMNOPQ
1Scrtutinized DC Batch Numbers : Scrtutinized DC Batch Numbers :
2MEDIUM1No. Packets109876543210Total ScriptsMEDIUM1
3Sl. NoCentre CodeSl. NoCentre Code
401001-OO/ 101015-OO/ 1
502001-OO/ 202016-OO/ 1
603001-OO/ 303019-OO/ 1
704002-OO/ 104020-OO/ 1
805004-OO/ 105020-OO/ 2
906004-OO/ 206023-OO/ 1
1007005-OO/ 107024-OO/ 1
1108005-OO/ 208024-OO/ 2
1209006-OO/ 109025-OO/ 1
1310006-OO/ 210025-OO/ 2
1411008-OO/ 111028-OO/ 1
1512008-OO/ 212030-OO/ 1
1613010-OO/ 113
1714010-OO/ 214
1815012-OO/ 115
1916012-OO/ 216
2017014-OO/ 117
2118014-OO/ 218
22MEDIUM2No. Packets109876543210Total ScriptsMEDIUM2
2301001-OO/ 101015-OO/ 1
2402002-OO/ 102016-OO/ 1
2503004-OO/ 103019-OO/ 1
2604005-OO/ 104019-OO/ 2
2705006-OO/ 105020-OO/ 1
2806008-OO/ 106023-OO/ 1
2907010-OO/ 107023-OO/ 2
3008012-OO/ 108024-OO/ 1
3109012-OO/ 209025-OO/ 1
3210014-OO/ 110028-OO/ 1
331111030-OO/ 1
341212
351313
361414
Sheet2
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

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
Back
Top