Spreadsheet: 165515d1341253999-excel-2007-help-setting-up-inventory-management-revised-test-inventory
Sheet: MASTER LIST

CO | DPT | VND | ITEM NUMBER | [NAME] | PID | QTY | COST | TOTAL
TES | 296 | 4 | 123456789000 | TEST ITEM 1 | SKULONGDESC1 | 1 | 7.5
TES | 296 | 4 | 123456789001 | TEST ITEM 2 | SKULONGDESC2 | 3 | 16.5
TES | 296 | 4 | 123456789002 | TEST ITEM 3 | SKULONGDESC3 | 1 | 16.5
TES | 296 | 4 | 123456789003 | TEST ITEM 4 | SKULONGDESC4 | 11 | 16.5
TES | 296 | 4 | 123456789004 | TEST ITEM 5 | SKULONGDESC5 | 1 | 31.5
TES | 296 | 4 | 123456789005 | TEST ITEM 6 | SKULONGDESC6 | 1 | 35
TES | 296 | 4 | 123456789006 | TEST ITEM 7 | SKULONGDESC7 | 3 | 17.5
TES | 296 | 4 | 123456789007 | TEST ITEM 8 | SKULONGDESC8 | 1 | 30
TES | 296 | 4 | 123456789008 | TEST ITEM 9 | SKULONGDESC9 | 3 | 34
TES | 296 | 4 | 123456789009 | TEST ITEM 10 | SKULONGDESC10 | 3 | 23
TES | 296 | 4 | 123456789010 | TEST ITEM 11 | SKULONGDESC11 | 3 | 16.5
TES | 296 | 4 | 123456789011 | TEST ITEM 12 | SKULONGDESC12 | 2 | 16.5
TES | 296 | 4 | 123456789012 | TEST ITEM 13 | SKULONGDESC13 | 1 | 23
TES | 296 | 4 | 123456789013 | TEST ITEM 14 | SKULONGDESC14 | 3 | 16.5
TES | 296 | 4 | 123456789014 | TEST ITEM 15 | SKULONGDESC15 | 1 | 16.5
TES | 296 | 4 | 123456789015 | TEST ITEM 16 | SKULONGDESC16 | 2 | 20
TES | 296 | 4 | 123456789016 | TEST ITEM 17 | SKULONGDESC17 | 1 | 20
TES | 296 | 4 | 123456789017 | TEST ITEM 18 | SKULONGDESC18 | 2 | 21.75
TES | 296 | 4 | 123456789018 | TEST ITEM 19 | SKULONGDESC19 | 3 | 33
TES | 296 | 4 | 123456789019 | TEST ITEM 20 | SKULONGDESC20 | 1 | 42
TES | 296 | 4 | 123456789020 | TEST ITEM 21 | SKULONGDESC21 | 2 | 16.5
TES | 296 | 4 | 123456789021 | TEST ITEM 22 | SKULONGDESC22 | 2 | 16.5
TES | 296 | 4 | 123456789022 | TEST ITEM 23 | SKULONGDESC23 | 2 | 16.5
TES | 296 | 4 | 123456789023 | TEST ITEM 24 | SKULONGDESC24 | 1 | 16.5
TES | 296 | 4 | 123456789024 | TEST ITEM 25 | SKULONGDESC25 | 1 | 17.5
TES | 296 | 4 | 123456789025 | TEST ITEM 26 | SKULONGDESC26 | 1 | 29
TES | 296 | 4 | 123456789026 | TEST ITEM 27 | SKULONGDESC27 | 3 | 23
TES | 296 | 4 | 123456789027 | TEST ITEM 28 | SKULONGDESC28 | 2 | 23
TES | 296 | 4 | 123456789028 | TEST ITEM 29 | SKULONGDESC29 | 2 | 29.5
TES | 296 | 4 | 123456789029 | TEST ITEM 30 | SKULONGDESC30 | 3 | 35
TES | 296 | 4 | 123456789030 | TEST ITEM 31 | SKULONGDESC31 | 2 | 38
TES | 296 | 4 | 123456789031 | TEST ITEM 32 | SKULONGDESC32 | 1 | 38
TES | 296 | 4 | 123456789032 | TEST ITEM 33 | SKULONGDESC33 | 1 | 16.5
TES | 296 | 4 | 123456789033 | TEST ITEM 34 | SKULONGDESC34 | 1 | 11.5
TES | 296 | 4 | 123456789034 | TEST ITEM 35 | SKULONGDESC35 | 2 | 15
TES | 296 | 4 | 123456789035 | TEST ITEM 36 | SKULONGDESC36 | 3 | 8.75
TES | 296 | 4 | 123456789036 | TEST ITEM 37 | SKULONGDESC37 | 2 | 23
TES | 296 | 4 | 123456789037 | TEST ITEM 38 | SKULONGDESC38 | 3 | 40
TES | 296 | 4 | 123456789038 | TEST ITEM 39 | SKULONGDESC39 | 1 | 17
TES | 296 | 4 | 123456789039 | TEST ITEM 40 | SKULONGDESC40 | 1 | 23
TES | 296 | 4 | 123456789040 | TEST ITEM 41 | SKULONGDESC41 | 1 | 23
TES | 296 | 4 | 123456789041 | TEST ITEM 42 | SKULONGDESC42 | 18 | 23
TES | 296 | 4 | 123456789042 | TEST ITEM 43 | SKULONGDESC43 | 2 | 23
TES | 296 | 4 | 123456789043 | TEST ITEM 44 | SKULONGDESC44 | 3 | 17
TES | 296 | 4 | 123456789044 | TEST ITEM 45 | SKULONGDESC45 | 1 | 10
TES | 296 | 4 | 123456789045 | TEST ITEM 46 | SKULONGDESC46 | 1 | 12.75
TES | 296 | 4 | 123456789046 | TEST ITEM 47 | SKULONGDESC47 | 1 | 9
TES | 296 | 4 | 123456789047 | TEST ITEM 48 | SKULONGDESC48 | 1 | 10
TES | 296 | 4 | 123456789048 | TEST ITEM 49 | SKULONGDESC49 | 5 | 12.75
TES | 296 | 4 | 123456789049 | TEST ITEM 50 | SKULONGDESC50 | 2 | 23
TES | 296 | 4 | 123456789050 | TEST ITEM 51 | SKULONGDESC51 | 3 | 16.5
TES | 296 | 4 | 123456789051 | TEST ITEM 52 | SKULONGDESC52 | 1 | 20
TES | 296 | 4 | 123456789052 | TEST ITEM 53 | SKULONGDESC53 | 2 | 35
TES | 296 | 4 | 123456789053 | TEST ITEM 54 | SKULONGDESC54 | 2 | 35
TES | 296 | 4 | 123456789054 | TEST ITEM 55 | SKULONGDESC55 | 2 | 23
TES | 296 | 4 | 123456789055 | TEST ITEM 56 | SKULONGDESC56 | 1 | 23
TES | 296 | 4 | 123456789056 | TEST ITEM 57 | SKULONGDESC57 | 6 | 23
TES | 296 | 4 | 123456789057 | TEST ITEM 58 | SKULONGDESC58 | 4 | 23
TES | 296 | 4 | 123456789058 | TEST ITEM 59 | SKULONGDESC59 | 1 | 23
TES | 296 | 4 | 123456789059 | TEST ITEM 60 | SKULONGDESC60 | 1 | 20
TES | 296 | 4 | 123456789060 | TEST ITEM 61 | SKULONGDESC61 | 1 | 20
TES | 296 | 4 | 123456789061 | TEST ITEM 62 | SKULONGDESC62 | 1 | 13
TES | 296 | 4 | 123456789062 | TEST ITEM 63 | SKULONGDESC63 | 1 | 13
TES | 296 | 4 | 123456789063 | TEST ITEM 64 | SKULONGDESC64 | 2 | 12.5
TES | 296 | 4 | 123456789064 | TEST ITEM 65 | SKULONGDESC65 | 2 | 12
TES | 296 | 4 | 123456789065 | TEST ITEM 66 | SKULONGDESC66 | 1 | 15
TES | 296 | 4 | 123456789066 | TEST ITEM 67 | SKULONGDESC67 | 1 | 17
TES | 296 | 4 | 123456789067 | TEST ITEM 68 | SKULONGDESC68 | 1 | 15
TES | 296 | 4 | 123456789068 | TEST ITEM 69 | SKULONGDESC69 | 1 | 18
TES | 296 | 4 | 123456789069 | TEST ITEM 70 | SKULONGDESC70 | 2 | 16.5
TES | 296 | 4 | 123456789070 | TEST ITEM 71 | SKULONGDESC71 | 1 | 16.5
TES | 296 | 4 | 123456789071 | TEST ITEM 72 | SKULONGDESC72 | 5 | 16.5
TES | 296 | 4 | 123456789072 | TEST ITEM 73 | SKULONGDESC73 | 7 | 16.5
TES | 296 | 4 | 123456789073 | TEST ITEM 74 | SKULONGDESC74 | 2 | 16.5
TES | 296 | 4 | 123456789074 | TEST ITEM 75 | SKULONGDESC75 | 1 | 33
TES | 296 | 4 | 123456789075 | TEST ITEM 76 | SKULONGDESC76 | 1 | 23
TES | 296 | 4 | 123456789076 | TEST ITEM 77 | SKULONGDESC77 | 4 | 40
TES | 296 | 4 | 123456789077 | TEST ITEM 78 | SKULONGDESC78 | 1 | 43
TES | 296 | 4 | 123456789078 | TEST ITEM 79 | SKULONGDESC79 | 1 | 40
TES | 296 | 40 | 123456789079 | TEST ITEM 80 | SKULONGDESC80 | 1 | 26
TES | 296 | 40 | 123456789080 | TEST ITEM 81 | SKULONGDESC81 | 1 | 26
TES | 296 | 40 | 123456789081 | TEST ITEM 82 | SKULONGDESC82 | 4 | 26
TES | 296 | 40 | 123456789082 | TEST ITEM 83 | SKULONGDESC83 | 2 | 23
TES | 296 | 40 | 123456789083 | TEST ITEM 84 | SKULONGDESC84 | 3 | 40
TES | 296 | 40 | 123456789084 | TEST ITEM 85 | SKULONGDESC85 | 1 | 40
TES | 296 | 40 | 123456789085 | TEST ITEM 86 | SKULONGDESC86 | 1 | 43
TES | 296 | 40 | 123456789086 | TEST ITEM 87 | SKULONGDESC87 | 2 | 26
TES | 296 | 40 | 123456789087 | TEST ITEM 88 | SKULONGDESC88 | 1 | 34
TES | 296 | 40 | 123456789088 | TEST ITEM 89 | SKULONGDESC89 | 1 | 24
TES | 296 | 40 | 123456789089 | TEST ITEM 90 | SKULONGDESC90 | 1 | 42
TES | 296 | 40 | 123456789090 | TEST ITEM 91 | SKULONGDESC91 | 1 | 35
TES | 296 | 40 | 123456789091 | TEST ITEM 92 | SKULONGDESC92 | 1 | 39
TES | 296 | 40 | 123456789092 | TEST ITEM 93 | SKULONGDESC93 | 1 | 15
TES | 296 | 40 | 123456789093 | TEST ITEM 94 | SKULONGDESC94 | 1 | 23
TES | 296 | 40 | 123456789094 | TEST ITEM 95 | SKULONGDESC95 | 8 | 16.5
TES | 296 | 40 | 123456789095 | TEST ITEM 96 | SKULONGDESC96 | 2 | 23
TES | 296 | 40 | 123456789096 | TEST ITEM 97 | SKULONGDESC97 | 1 | 40
TES | 296 | 40 | 123456789097 | TEST ITEM 98 | SKULONGDESC98 | 1 | 60
TES | 296 | 40 | 123456789098 | TEST ITEM 99 | SKULONGDESC99 | 2 | 34
TES | 296 | 40 | 123456789099 | TEST ITEM 100 | SKULONGDESC100 | 1 | 100
TES | 296 | 40 | 123456789100 | TEST ITEM 101 | SKULONGDESC101 | 1 | 30
TES | 296 | 40 | 123456789101 | TEST ITEM 102 | SKULONGDESC102 | 1 | 21.75
TES | 296 | 40 | 123456789102 | TEST ITEM 103 | SKULONGDESC103 | 2 | 21
TES | 296 | 40 | 123456789103 | TEST ITEM 104 | SKULONGDESC104 | 2 | 20
TES | 296 | 40 | 123456789104 | TEST ITEM 105 | SKULONGDESC105 | 4 | 20
TES | 296 | 40 | 123456789105 | TEST ITEM 106 | SKULONGDESC106 | 1 | 20
TES | 296 | 40 | 123456789106 | TEST ITEM 107 | SKULONGDESC107 | 4 | 25
TES | 296 | 40 | 123456789107 | TEST ITEM 108 | SKULONGDESC108 | 7 | 20
TES | 296 | 40 | 123456789108 | TEST ITEM 109 | SKULONGDESC109 | 11 | 21