Spreadsheet: 155595d1336986321-need-help-with-macros-for-invoice-worksheet-invoice-sheet-rev3-me
Sheet: Sheet1

Code | Description | Price |  | STOCK |  |  | STOCK
203010 | PART A | 2 |  | 10 |  |  | 10
203011 | PART B | 4 |  | 16 |  |  | 16
203012 | PART C | 6 |  | 30 |  |  | 30
203013 | PART D | 8 |  | 35 |  |  | 35
203014 | PART E | 10 |  | 48 |  |  | 48
203015 | PART F | 12 |  | 60 |  |  | 60
203016 | PART G | 14 |  | 70 |  |  | 70
20B010 | NUTS | 1 |  | 100 |  |  | 100
20B011 | BOLTS | 1 |  | 100 |  |  | 100
20B012 | NAILS | 0.5 |  | 100 |  |  | 100
20B013 | THUMB TACKS | 0.25 |  | 100 |  |  | 100
20B014 | PANEL PINS | 0.2 |  | 100 |  |  | 100
20B015 | SCREW COUNTERSINK | 0.6 |  | 100 |  |  | 100
20B016 | SCREW POZI DRIVE | 0.75 |  | 100 |  |  | 100
20B017 | [NAME] | 0.65 |  | 100 |  |  | 100
50EFT1 | INSULATION TAPE | 0.5 |  | 50 |  |  | 50
50EFT2 | MASKING TAPE 10MM | 0.75 |  | 50 |  |  | 50
50EFT3 | BUFF TAPE | 1 |  | 50 |  |  | 50
50EFT4 | SELLO TAPE | 1 |  | 50 |  |  | 50
50EFT5 | DOUBLE SIDED TAPE | 1 |  | 50 |  |  | 50
50EFT6 | [NAME] | 1 |  | 50 |  |  | 50
50EFT7 | RUBBER DOOR SEAL FRIDGE | 1 |  | 50 |  |  | 50
50EFT8 | RUBBER DOOR SEAL AUTO | 1 |  | 50 |  |  | 50
50EFT9 | TAPE SILICON SELF FUSING | 1 |  | 50 |  |  | 50
50EFT10 | CONTRACTERS STRETCH TAPE ELECTRICAL | 1 |  | 50 |  |  | 50
50EFT11 | MASKING TAPE 15MM | 1.02 |  | 50 |  |  | 50
50EFT12 | MASKING TAPE 50MM | 1.8 |  | 50 |  |  | 50
50EFT13 | MASKING TAPE 25MM | 1.25 |  | 50 |  |  | 50
50EFT14 | MASKING TAPE 20MM | 1.2 |  | 50 |  |  | 50
30CH02 | PAINT COLORING PIGMENT YELLOW | 0.85 |  | 10 |  |  | 10
30CH03 | PAINT COLORING PIGMENT BLUE | 0.8 |  | 10 |  |  | 10
30CH04 | PAINT COLORING PIGMENT GREEN | 0.8 |  | 10 |  |  | 10
30CH05 | PAINT COLORING PIGMENT BLACK | 0.8 |  | 10 |  |  | 10
30CH06 | PAINT COLORING PIGMENT RED | 0.85 |  | 10 |  |  | 10
30CH07 | TURPENTINE | 1 |  | 10 |  |  | 10
30CH08 | THINNERS | 2 |  | 10 |  |  | 10
30CH09 | RESIN | 3 |  | 10 |  |  | 10
30CH10 | CATALYST | 1.5 |  | 10 |  |  | 10
30CH11 | PAINT REMOVER | 2 |  | 10 |  |  | 10
700B5 | ADHESIVE ACRYLIC WHITE | 1.15 |  | 10 |  |  | 10
700B6 | ADHESIVE ACRYLIC BLACK | 1.15 |  | 10 |  |  | 10
700B7 | ADHESIVE ACRYLIC GREEN | 1.15 |  | 10 |  |  | 10
700B8 | ADHESIVE ACRYLIC BROWN | 1.15 |  | 10 |  |  | 10
700B9 | ADHESIVE ACRYLIC BEIGE | 1.15 |  | 10 |  |  | 10
700B10 | ADHESIVE ACRYLIC YELLOW | 1.15 |  | 10 |  |  | 10
700B11 | ADHESIVE ACRYLIC RED | 1.15 |  | 10 |  |  | 10
700B12 | ADHESIVE ACRYLIC ORANGE | 1.15 |  | 10 |  |  | 10
700B13 | ADHESIVE ACRYLIC BLUE | 1.15 |  | 10 |  |  | 10
700B14 | ADHESIVE ACRYLIC GREY | 1.15 |  | 10 |  |  | 10
700B15 | ADHESIVE ACRYLIC PINK | 1.15 |  | 10 |  |  | 10
700B16 | ADHESIVE SILICON CLEAR | 1.15 |  | 10 |  |  | 10
700B17 | ADHESIVE SILICON WHITE | 1.15 |  | 10 |  |  | 10
700B18 | ADHESIVE SILICON BLACK | 1.15 |  | 10 |  |  | 10
700B19 | ADHESIVE SILICON GREEN | 1.15 |  | 10 |  |  | 10
700B20 | ADHESIVE SILICON BLUE | 1.15 |  | 10 |  |  | 10
4LPT02 | ANY OTHER 1 |  |  | 0 |  |  | 0
4LPT03 | ANY OTHER 2 |  |  | 0 |  |  | 0
4LPT04 | ANY OTHER 3 |  |  | 0 |  |  | 0
4LPT05 | ANY OTHER 4 |  |  | 0 |  |  | 0
4LPT06 | ANY OTHER 5 |  |  | 0 |  |  | 0
4LPT07 | ANY OTHER 6 |  |  | 0 |  |  | 0
4LPT08 | AND ANOTHER 10 |  |  | 0 |  |  | 0
4LPT09 | AND ANOTHER 11 |  |  | 0 |  |  | 0
4LPT10 | AND ANOTHER 12 |  |  | 0 |  |  | 0
4LPT11 | AND ANOTHER 13 |  |  | 0 |  |  | 0
4LPT12 | AND ANOTHER 14 |  |  | 0 |  |  | 0
4LPT13 | AND ANOTHER 15 |  |  | 0 |  |  | 0
4LPT14 | AND ANOTHER 16 |  |  | 0 |  |  | 0
4LPT15 | AND ANOTHER 17 |  |  | 0 |  |  | 0
4LPT16 | AND ANOTHER 18 |  |  | 0 |  |  | 0
4LPT17 | AND ANOTHER 19 |  |  | 0 |  |  | 0
4LPT18 | AND ANOTHER 20 |  |  | 0 |  |  | 0
4LPT19 | AND ANOTHER 21 |  |  | 0 |  |  | 0
4LPT20 | AND ANOTHER 22 |  |  | 0 |  |  | 0
4LPT21 | AND ANOTHER 23 |  |  | 0 |  |  | 0
4LPT22 | AND ANOTHER 24 |  |  | 0 |  |  | 0
4LPT23 | AND ANOTHER 25 |  |  | 0 |  |  | 0
4LPT24 | AND ANOTHER 26 |  |  | 0 |  |  | 0
4LPT25 | AND ANOTHER 27 |  |  | 0 |  |  | 0
4LPT26 | WHAT ELSE 1 |  |  | 0 |  |  | 0
4LPT27 | WHAT ELSE 2 |  |  | 0 |  |  | 0
4LPT28 | WHAT ELSE 3 |  |  | 0 |  |  | 0
4LPT29 | WHAT ELSE 4 |  |  | 0 |  |  | 0
4LPT30 | WHAT ELSE 5 |  |  | 0 |  |  | 0
4LPT31 | WHAT ELSE 6 |  |  | 0 |  |  | 0
4LPT32 | WHAT ELSE 7 |  |  | 0 |  |  | 0
4LPT33 | WHAT ELSE 8 |  |  | 0 |  |  | 0
4LPT34 | WHAT ELSE 9 |  |  | 0 |  |  | 0
4LPT35 | WHAT ELSE 10 |  |  | 0 |  |  | 0
4LPT36 | WHAT ELSE 11 |  |  | 0 |  |  | 0
4LPT37 | WHAT ELSE 12 |  |  | 0 |  |  | 0
4LPT38 | WHAT ELSE 13 |  |  | 0 |  |  | 0
4LPT39 | WHAT ELSE 14 |  |  | 0 |  |  | 0
4LPT40 | WHAT ELSE 15 |  |  | 0 |  |  | 0
4LPT41 | WHAT ELSE 16 |  |  | 0 |  |  | 0
4LPT42 | WHAT ELSE 17 |  |  | 0 |  |  | 0
4LPT43 | WHAT ELSE 18 |  |  | 0 |  |  | 0
40ATL1 | PIES CORNISH | 1 |  | 20 |  |  | 20
40ATL2 | PIES STEAK & KIDNEY | 1 |  | 20 |  |  | 20
40ATL3 | PIES [NAME] | 1 |  | 20 |  |  | 20
40ATL4 | PIES PEPPER STEAK | 1 |  | 20 |  |  | 20
40ATL5 | PIES [NAME] AND ONION | 1 |  | 20 |  |  | 20
40ATL6 | PIES CHICKEN | 1 |  | 20 |  |  | 20
40ATL7 | PIES CHICKEN & MUSHROOM | 1 |  | 20 |  |  | 20
40ATL8 | PIES SAUSAGE ROLL CHICKEN | 1 |  | 20 |  |  | 20
40ATL9 | PIES SAUSAGE ROLL BEEF | 1 |  | 20 |  |  | 20
40ATL10 | PIES LAMB CURRY | 1 |  | 20 |  |  | 20
40ATL11 | PIES CHICKEN CURRY | 1 |  | 20 |  |  | 20
40ATL12 | PIES BEEF CURRY | 1 |  | 20 |  |  | 20
40ATL13 | SAMOOSA | 0.5 |  | 20 |  |  | 20
40ATL14 | CHILLI BITE | 0.3 |  | 20 |  |  | 20
40ATL15 | RUSSIAN | 1 |  | 20 |  |  | 20
40ATL16 | FRANKFRUTER | 1 |  | 20 |  |  | 20
40ATL17 | VIENNA | 0.5 |  | 20 |  |  | 20
40ATL18 | SAUSAGE BEEF | 1 |  | 20 |  |  | 20
40ATL19 | SAUSAGE PORK | 0.9 |  | 20 |  |  | 20
40ATL20 | SAUSAGE CHICKEN | 0.8 |  | 20 |  |  | 20
40ATL21 | POTATO CRISPS PLAIN SALTED | 0.4 |  | 50 |  |  | 50
40ATL22 | POTATO CRISPS SALT & VINEGAR | 0.4 |  | 50 |  |  | 50
40ATL23 | POTATO [NAME] | 0.4 |  | 50 |  |  | 50
40ATL24 | POTATO CRISPS CHEESE & ONION | 0.4 |  | 50 |  |  | 50
40ATL25 | POTATO CRISPS SOUR CREAM | 0.4 |  | 50 |  |  | 50
40ATL26 | POTATO CRISPS CHILLI | 0.4 |  | 50 |  |  | 50
40ATL27 | CHEESE NACKS | 0.35 |  | 50 |  |  | 50
40ATL28 | CORN BITES | 0.5 |  | 50 |  |  | 50
40ATL29 | CHEESE CURLS | 0.35 |  | 50 |  |  | 50
40ATL30 | POP CORN CARAMEL | 0.25 |  | 50 |  |  | 50