Spreadsheet: 45932d1244709702-using-vba-to-copy-down-to-multiple-cells-in-another-worksheet-copy-example
Sheet: LISTS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RATIO | STD
 | PROFILE |  |  | LONG EDGE DETAIL |  |  | BACKING DETAIL |  |  |  | CORE BOARD |  |  |  | SHORT EDGES |  |  | PACKING |  |  | EDGE PROTECTION |  |  | EDGING STRIPS |  |  | FACTORY |  |  |  |  |  |  | [NAME] |  |  | SPARE |  |  | SUPPLIERS |  | CODE | BOARD | LENGTH | WIDTH | THK | TYPE |  |  | W RAT | CHIP WIDTH |  | L RAT | CHIP LENGTH |  | 0 | 915 |  | W YIELD | L YIELD |  | KRAFT |  |  |  | L | W | LAM E
 | 4 x 4 | A |  | SPF | A |  | KRAFT | A |  | A | STD Chip | A | STD |  | Matching Acrylic | A |  | Shrink | A |  | None | A |  | 2 x 1300mm | A |  | Wingate | A |  |  |  |  |  | None | A |  | A | Special Price |  | Arpa |  | A | 3050X1325X38 STD | 3050 | 1325 | 38 | STD |  |  | 6393.44262295082 | 500 | 0500 | 9180.327868852459 | 2800 |  | 2295.081967213113 | 680 |  | 1.639344262295082 | 0.9180327868852459 |  | 240 | MUNK01KP100024090GM2 | Kraft Paper 90 g / m2  240mm |  | 3050 | 600 | MUNK01LE30500600160GM2 | Laminate E 160 g / m2  3050 x 600
 |  | B |  | DPF | B |  | Any Laminate | B |  | B | MR Chip | B | MRC |  | Blank | B |  | Bulk | B |  | 2 x C'Board L Channel | B |  | 1 x Full Length | B |  | Glaisdale | B |  |  |  |  |  | ID Label | B |  | B |  |  | Duropal |  | A | 3050X1220X38 STD | 3050 | 1220 | 38 | STD |  |  | 9836.065573770491 | 605 | 0605 | 0 | 3050 |  | 9836.065573770491 | 605 |  | 1.983606557377049 | 1 |  | 310 | MUNK01KP100031090GM2 | Kraft Paper 90 g / m2  310mm |  | 3050 | 900 | MUNK01LE30500900160GM2 | Laminate E 160 g / m2  3050 x 900
 | 6 x 6 | C |  | Corner Solution | C |  | D C White | C |  | C | MR MDF | C | MRM |  | Clean Cut | C |  | [NAME] | C |  | 4 Corners | C |  | 1 x Full Separate | C |  | Specials | C |  |  |  |  |  | ID & Barcode | C |  | C |  |  | Egger |  | A | 3050X0915X38 STD | 3050 | 915 | 38 | STD |  |  | 0 | 610 | 0610 | 2000 | 3660 |  | 2131.147540983607 | 675 |  | 2 | 1.2 |  | 320 | MUNK01KP100032090GM2 | Kraft Paper 90 g / m2  320mm |  | 4120 | 200 | MUNK01LE41200200160GM2 | Laminate E 160 g / m2  4120 x 200
 | 8 x8 | D |  | None | D |  | None | D |  | D | STD MDF | D | MDF |  | [NAME] | D |  | [NAME] | D |  | 4 Edges Poly Strips | D |  | None | D |  | Specials S/S | D |  |  |  |  |  |  | D |  | D |  |  | [NAME] |  | A | 3050X0605X38 STD | 3050 | 605 | 38 | STD |  |  | 2131.147540983607 | 675 | 0675 | 3508.196721311476 | 4120 |  | 0 | 1220 |  | 2.213114754098361 | 1.350819672131148 |  | 370 | MUNK01KP100037090GM2 | Kraft Paper 90 g / m2  370mm |  | 4120 | 225 | MUNK01LE41200225160GM2 | Laminate E 160 g / m2  4120 x 225
 | 8 x8 Axiom | E |  |  | E |  | Lam E | E |  | E | Ply | E | PLYW |  | Supreme Karonia | E |  | [NAME] | E |  | [NAME] | E |  | 1300mm Separate | E |  |  | E |  |  |  |  |  |  | E |  | E |  |  | Kronospan |  | A | 3050X1320X28 STD | 3050 | 1320 | 28 | STD |  |  | 2295.081967213113 | 680 | 0680 | 6426.229508196721 | 5010 |  | 3442.622950819674 | 1325 |  | 2.229508196721311 | 1.642622950819672 |  | 510 | MUNK01KP100051090GM2 | Kraft Paper 90 g / m2  510[NAME] |  | 4120 | 250 | MUNK01LE41200250160GM2 | Laminate E 160 g / m2  4120 x 250
 | 8 x8 MFI | F |  |  | F |  | Face Laminate | F |  | F | S/S Acrylic | F | SSAC |  | Face Laminate | F |  |  | F |  | Superme 4 Edges | F |  | 2 x Full Length | F |  |  | F |  |  |  |  |  |  | F |  | F |  |  | LPR |  | A | 3050X1180X28 STD | 3050 | 1180 | 28 | STD |  |  | 0 | 915 | 0915 |  |  |  | 1639.344262295079 | 1270 |  | 3 |  |  | 560 | MUNK01KP100056090GM2 | Kraft Paper 90 g / m2  560mm |  | 4120 | 600 | MUNK01LE41200600160GM2 | Laminate E 160 g / m2  4120 x 600
 | 9 x 9 | G |  |  | G |  | [NAME] | G |  | G | Fire Ret. Chip | G | FRCH |  |  | G |  | Shrink GAP | G |  |  | G |  | Off Cuts | G |  |  | G |  |  |  |  |  |  | G |  | G |  |  | Misc |  | A | 3050X1220X28 STD | 3050 | 1220 | 28 | STD |  |  | 8688.524590163934 | 1180 | 1180 |  |  |  | 8688.524590163934 | 1180 |  | 3.868852459016393 |  |  | 610 | MUNK01KP100061090GM2 | Kraft Paper 90 g / m2  610mm |  | 4120 | 900 | MUNK01LE41200900160GM2 | Laminate E 160 g / m2  4120 x 900
 | Cistern Access Cover | H |  | Cistern Lid | Z |  |  | H |  | H | Eurolite Chip | H | EURO |  |  | H |  | [NAME] | H |  |  | H |  |  | H |  |  | H |  |  |  |  |  |  | H |  | H |  |  | [NAME] |  | A | 3050X1220X18 STD | 3050 | 1220 | 18 | STD |  |  | 0 | 1220 | 1220 |  |  |  | 3278.688524590168 | 1320 |  | 4 |  |  | 680 | MUNK01KP100068090GM2 | Kraft Paper 90 g / m2  680mm |  | 5010 | 180 | MUNK01LE50100180160GM2 | Laminate E 160 g / m2  5010 x 180
 | 11 x 11 Window Boards | I |  |  |  |  |  | I |  | I |  | I |  |  |  | I |  | [NAME] | I |  |  | I |  |  | I |  |  | I |  |  |  |  |  |  | I |  | I |  |  | Sonae |  | A | 3050X1220X50 STD | 3050 | 1220 | 50 | STD |  |  | 983.6065573770459 | 1250 | 1250 |  |  |  | 8688.524590163934 | 1180 |  | 4.098360655737705 |  |  | 710 | MUNK01KP100071090GM2 | Kraft Paper 90 g / m2  710mm |  | 5010 | 200 | MUNK01LE50100200160GM2 | Laminate E 160 g / m2  5010 x 200
 |  | J |  |  |  |  |  | J |  | J |  | J |  |  | Non Matching Acrylic | J |  | Supreme [NAME] | J |  |  | J |  |  | J |  |  | J |  |  |  |  |  |  | J |  | J |  |  | Thermopal |  | A | 3660X0915X38 STD | 3660 | 915 | 38 | STD |  |  | 1639.344262295079 | 1270 | 1270 |  |  |  |  | MRC |  | 4.163934426229508 |  |  | 910 | MUNK01KP100091090GM2 | Kraft Paper 90 g / m2  910mm |  | 5010 | 225 | MUNK01LE50100225160GM2 | Laminate E 160 g / m2  5010 x 225
 | 10 x 10 | K |  |  |  |  |  | K |  | K |  | K |  |  | Cistern Lid | K |  |  | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K |  | K |  |  |  |  | A | 3660X0675X38 STD | 3660 | 675 | 38 | STD |  |  | 3278.688524590168 | 1320 | 1320 |  |  |  | 0 | 1220 |  | 4.327868852459017 |  |  |  |  |  |  | 5010 | 250 | MUNK01LE50100250160GM2 | Laminate E 160 g / m2  5010 x 250
 |  | L |  |  |  |  |  |  |  | L |  | L |  |  |  |  |  |  | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L |  | L | Left Hand |  |  |  | A | 3660X1220X38 STD | 3660 | 1220 | 38 | STD |  |  | 3442.622950819674 | 1325 | 1325 |  |  |  | 9836.065573770491 | 605 |  | 4.344262295081967 |  |  |  |  |  |  | 5010 | 300 | MUNK01LE50100300160GM2 | Laminate E 160 g / m2  5010 x 300
 | 12 Top Radius | M |  |  |  |  |  |  |  | M |  | M |  |  |  |  |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M |  | M |  |  |  |  | A | 3660X1270X28 STD | 3660 | 1270 | 28 | STD |  |  |  |  |  |  |  |  |  | EURO |  |  |  |  |  |  |  |  | 5010 | 600 | [NAME] | Laminate E 160 g / m2  5010 x 600
 |  | N |  |  |  |  |  |  |  | N |  | N |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  | N |  |  |  |  | A | 4120X0915X38 STD | 4120 | 915 | 38 | STD |  |  |  |  |  |  |  |  |  | 500
 |  | O |  |  |  |  |  |  |  | O |  | O |  |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  | O |  |  |  |  | A | 4120X0680X38 STD | 4120 | 680 | 38 | STD |  |  |  |  |  |  |  |  |  | MRM |  |  |  |  |  |  |  |  |  |  | FORM0130501220078511UNN | Laminate Brown Backing 3050 x 1220 x 0.7
 |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | A | 4120X0605X38 STD | 4120 | 605 | 38 | STD |  |  |  |  |  |  |  |  |  | 1220 |  |  |  |  |  |  |  |  |  |  | MISC013050130007MISC01N | Laminate White Liner 3050 x 1300 x 0.7
 | 12 x 12 | Q |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 4120X1270X28 STD | 4120 | 1270 | 28 | STD |  |  |  |  |  |  |  |  |  | MDF
 |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 4120X1180X28 STD | 4120 | 1180 | 28 | STD |  |  |  |  |  |  |  |  |  | 1220
 | S/E | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 4120X1320X28 STD | 4120 | 1320 | 28 | STD
 | S/E Flat Bonding | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BOARD SIZES |  |  |  |  | B | 3050X1220X38 MRC | 3050 | 1220 | 38 | MRC
 | S/E Matching Acrylic | U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2800 |  |  |  |  | B | 3050X0605X38 MRC | 3050 | 605 | 38 | MRC
 | S/E Non Matching Acrylic | V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3050 |  |  |  |  | B | 3050X1220X28 MRC | 3050 | 1220 | 28 | MRC
 | S/E Matching Laminate | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3660 |  |  |  |  | B | 3050X0605X28 MRC | 3050 | 605 | 28 | MRC
 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4100 |  |  |  |  | B | 3050X1220X22 MRC | 3050 | 1220 | 22 | MRC
 | Supreme Karonia | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 |  |  |  |  | B | 4120X1220X38 MRC | 4120 | 1220 | 38 | MRC |  |  |  |  |  |  |  |  |  |  |  | ORANGE MEANS "INDIVIDUAL TO EACH CODE"
 | [NAME] | Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 4120X0605X38 MRC | 4120 | 605 | 38 | MRC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 4120X0605X28 MRC | 4120 | 605 | 28 | MRC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 4120X1250X22 MRC | 4120 | 1250 | 22 | MRC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 5010X1250X22 MRC | 5010 | 1250 | 22 | MRC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 3050X1220X30 MRM | 3050 | 1220 | 30 | MRM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 3050X1220X06 MDF | 3050 | 1220 | 6 | MDF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 3050X1220X18 MDF | 3050 | 1220 | 18 | MDF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 2800X0500X50 EUR | 2800 | 500 | 50 | EUR |  |  |  | WORKING |  |  | WORKING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMAINDER |  |  | REMAINDER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3050 | 915 |  | 28 | STD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIDTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORKING |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A