Spreadsheet: 111311d1307704459-how-to-make-a-dropdown-list-that-is-more-advanced-test
Sheet: Daily records

 | INVENTORY - DAILY RECORDS |  |  |  |  |  |  |  | INVENTORY LIST
 | DATE | ITEM | IN | OUT |  |  |  |  | ITEM
1 |  | A100 | 100 |  |  |  |  | 1 | A100
2 |  | A102 |  | 200 |  |  |  | 2 | [NAME]
3 |  | A103 | 105 |  |  |  |  | 3 | A102
4 |  | A108 | 130 |  |  |  |  | 4 | A103
 |  |  |  |  |  |  |  | 5 | A104
 |  |  |  |  |  |  |  | 6 | A105
 |  |  |  |  |  |  |  | 7 | A106
 | READ ME |  |  |  |  |  |  | 8 | A107
 | The function of the worksheet to record the daily transactions |  |  |  |  |  |  | 9 | A108
 | for the inventory; how many are consumed for production per day |  |  |  |  |  |  | 10 | A109
 | and how many are received from suppliers. |  |  |  |  |  |  | 11 | A110
 | The worksheet 'Reports' give the total IN and OUR for the month |  |  |  |  |  |  | 12 | A111
 |  |  |  |  |  |  |  | 13 | A112
 | As you can see, I put a dropdown list in cells C5 to C8 to make it easier |  |  |  |  |  |  | 14 | A113
 | for the operator to input the transactions and to reduce mistakes. |  |  |  |  |  |  | 15 | A114
 | But the problem is the inventory list is huge, and since the dropdown list width |  |  |  |  |  |  | 16 | A115
 | is too small, I feel that this can be inconvenient for the operator to scroll |  |  |  |  |  |  | 17 | A116
 | down and choose the correct item. |  |  |  |  |  |  | 18 | A117
 |  |  |  |  |  |  |  | 19 | A118
 | My question is, is there a way to make this much more efficient? |  |  |  |  |  |  | 20 | A119
 | one way that I've thought about is to let the operator type |  |  |  |  |  |  | 21 | A120
 | a partial word of the item, and then Excel autofill for them AND also |  |  |  |  |  |  | 22 | A121
 | when you scroll down the dropdown list, only item that begins with that partial |  |  |  |  |  |  | 23 | A122
 | word appears. |  |  |  |  |  |  | 24 | A123
 |  |  |  |  |  |  |  | 25 | A124
 | For example, when the operator types in A1, Excel immediately |  |  |  |  |  |  | 26 | A125
 | autofills it with A100, and if the operator scrol down the dropdown list, |  |  |  |  |  |  | 27 | A126
 | only items that begin with [NAME] appears. |  |  |  |  |  |  | 28 | A127
 |  |  |  |  |  |  |  | 29 | A128
 | Is this possible in Excel? If not is there a more efficient solution than having |  |  |  |  |  |  | 30 | A129
 | to scroll down the huge list and manually click the item? |  |  |  |  |  |  | 31 | A130
 |  |  |  |  |  |  |  | 32 | A131
 |  |  |  |  |  |  |  | 33 | A132
 |  |  |  |  |  |  |  | 34 | A133
 |  |  |  |  |  |  |  | 35 | A134
 |  |  |  |  |  |  |  | 36 | A135
 |  |  |  |  |  |  |  | 37 | A136
 |  |  |  |  |  |  |  | 38 | A137
 |  |  |  |  |  |  |  | 39 | A138
 |  |  |  |  |  |  |  | 40 | A139
 |  |  |  |  |  |  |  | 41 | A140
 |  |  |  |  |  |  |  | 42 | A141
 |  |  |  |  |  |  |  | 43 | A142
 |  |  |  |  |  |  |  | 44 | A143
 |  |  |  |  |  |  |  | 45 | A144
 |  |  |  |  |  |  |  | 46 | A145
 |  |  |  |  |  |  |  | 47 | A146
 |  |  |  |  |  |  |  | 48 | A147
 |  |  |  |  |  |  |  | 49 | A148
 |  |  |  |  |  |  |  | 50 | A149
 |  |  |  |  |  |  |  | 51 | A150
 |  |  |  |  |  |  |  | 52 | A151
 |  |  |  |  |  |  |  | 53 | A152
 |  |  |  |  |  |  |  | 54 | A153
 |  |  |  |  |  |  |  | 55 | A154
 |  |  |  |  |  |  |  | 56 | A155
 |  |  |  |  |  |  |  | 57 | A156
 |  |  |  |  |  |  |  | 58 | A157
 |  |  |  |  |  |  |  | 59 | A158
 |  |  |  |  |  |  |  | 60 | A159
 |  |  |  |  |  |  |  | 61 | A160
 |  |  |  |  |  |  |  | 62 | A161
 |  |  |  |  |  |  |  | 63 | A162
 |  |  |  |  |  |  |  | 64 | A163
 |  |  |  |  |  |  |  | 65 | A164
 |  |  |  |  |  |  |  | 66 | A165
 |  |  |  |  |  |  |  | 67 | A166
 |  |  |  |  |  |  |  | 68 | A167
 |  |  |  |  |  |  |  | 69 | A168
 |  |  |  |  |  |  |  | 70 | A169
 |  |  |  |  |  |  |  | 71 | A170
 |  |  |  |  |  |  |  | 72 | A171
 |  |  |  |  |  |  |  | 73 | A172
 |  |  |  |  |  |  |  | 74 | A173
 |  |  |  |  |  |  |  | 75 | A174
 |  |  |  |  |  |  |  | 76 | A175
 |  |  |  |  |  |  |  | 77 | A176
 |  |  |  |  |  |  |  | 78 | A177
 |  |  |  |  |  |  |  | 79 | A178
 |  |  |  |  |  |  |  | 80 | A179
 |  |  |  |  |  |  |  | 81 | A180
 |  |  |  |  |  |  |  | 82 | A181
 |  |  |  |  |  |  |  | 83 | A182
 |  |  |  |  |  |  |  | 84 | A183
 |  |  |  |  |  |  |  | 85 | A184
 |  |  |  |  |  |  |  | 86 | A185
 |  |  |  |  |  |  |  | 87 | A186
 |  |  |  |  |  |  |  | 88 | A187
 |  |  |  |  |  |  |  | 89 | A188
 |  |  |  |  |  |  |  | 90 | A189
 |  |  |  |  |  |  |  | 91 | A190
 |  |  |  |  |  |  |  | 92 | A191
 |  |  |  |  |  |  |  | 93 | A192
 |  |  |  |  |  |  |  | 94 | A193
 |  |  |  |  |  |  |  | 95 | A194
 |  |  |  |  |  |  |  | 96 | A195
 |  |  |  |  |  |  |  | 97 | A196
 |  |  |  |  |  |  |  | 98 | A197
 |  |  |  |  |  |  |  | 99 | A198
 |  |  |  |  |  |  |  | 100 | A199
 |  |  |  |  |  |  |  | 101 | A200
 |  |  |  |  |  |  |  | 102 | A201
 |  |  |  |  |  |  |  | 103 | A202
 |  |  |  |  |  |  |  | 104 | A203
 |  |  |  |  |  |  |  | 105 | A204
 |  |  |  |  |  |  |  | 106 | A205
 |  |  |  |  |  |  |  | 107 | A206
 |  |  |  |  |  |  |  | 108 | A207
 |  |  |  |  |  |  |  | 109 | A208
 |  |  |  |  |  |  |  | 110 | A209
 |  |  |  |  |  |  |  | 111 | A210
 |  |  |  |  |  |  |  | 112 | A211
 |  |  |  |  |  |  |  | 113 | A212
 |  |  |  |  |  |  |  | 114 | A213
 |  |  |  |  |  |  |  | 115 | A214
 |  |  |  |  |  |  |  | 116 | A215
 |  |  |  |  |  |  |  | 117 | A216
 |  |  |  |  |  |  |  | 118 | A217
 |  |  |  |  |  |  |  | 119 | A218
 |  |  |  |  |  |  |  | 120 | A219
 |  |  |  |  |  |  |  | 121 | A220
 |  |  |  |  |  |  |  | 122 | A221
 |  |  |  |  |  |  |  | 123 | A222
 |  |  |  |  |  |  |  | 124 | A223
 |  |  |  |  |  |  |  | 125 | A224
 |  |  |  |  |  |  |  | 126 | A225
 |  |  |  |  |  |  |  | 127 | A226
 |  |  |  |  |  |  |  | 128 | A227
 |  |  |  |  |  |  |  | 129 | A228
 |  |  |  |  |  |  |  | 130 | A229
 |  |  |  |  |  |  |  | 131 | A230
 |  |  |  |  |  |  |  | 132 | A231
 |  |  |  |  |  |  |  | 133 | A232
 |  |  |  |  |  |  |  | 134 | A233
 |  |  |  |  |  |  |  | 135 | A234
 |  |  |  |  |  |  |  | 136 | A235
 |  |  |  |  |  |  |  | 137 | A236
 |  |  |  |  |  |  |  | 138 | A237
 |  |  |  |  |  |  |  | 139 | A238
 |  |  |  |  |  |  |  | 140 | A239
 |  |  |  |  |  |  |  | 141 | A240
 |  |  |  |  |  |  |  | 142 | A241
 |  |  |  |  |  |  |  | 143 | A242
 |  |  |  |  |  |  |  | 144 | A243
 |  |  |  |  |  |  |  | 145 | A244
 |  |  |  |  |  |  |  | 146 | A245
 |  |  |  |  |  |  |  | 147 | A246
 |  |  |  |  |  |  |  | 148 | A247
 |  |  |  |  |  |  |  | 149 | A248
 |  |  |  |  |  |  |  | 150 | A249
 |  |  |  |  |  |  |  | 151 | A250
 |  |  |  |  |  |  |  | 152 | A251
 |  |  |  |  |  |  |  | 153 | A252
 |  |  |  |  |  |  |  | 154 | A253
 |  |  |  |  |  |  |  | 155 | A254
 |  |  |  |  |  |  |  | 156 | A255
 |  |  |  |  |  |  |  | 157 | A256
 |  |  |  |  |  |  |  | 158 | A257
 |  |  |  |  |  |  |  | 159 | A258
 |  |  |  |  |  |  |  | 160 | A259
 |  |  |  |  |  |  |  | 161 | A260
 |  |  |  |  |  |  |  | 162 | A261
 |  |  |  |  |  |  |  | 163 | A262
 |  |  |  |  |  |  |  | 164 | A263
 |  |  |  |  |  |  |  | 165 | A264
 |  |  |  |  |  |  |  | 166 | A265
 |  |  |  |  |  |  |  | 167 | A266
 |  |  |  |  |  |  |  | 168 | A267
 |  |  |  |  |  |  |  | 169 | A268
 |  |  |  |  |  |  |  | 170 | A269
 |  |  |  |  |  |  |  | 171 | A270
 |  |  |  |  |  |  |  | 172 | A271
 |  |  |  |  |  |  |  | 173 | A272
 |  |  |  |  |  |  |  | 174 | A273
 |  |  |  |  |  |  |  | 175 | A274
 |  |  |  |  |  |  |  | 176 | A275
 |  |  |  |  |  |  |  | 177 | A276
 |  |  |  |  |  |  |  | 178 | A277
 |  |  |  |  |  |  |  | 179 | A278
 |  |  |  |  |  |  |  | 180 | A279
 |  |  |  |  |  |  |  | 181 | A280
 |  |  |  |  |  |  |  | 182 | A281
 |  |  |  |  |  |  |  | 183 | A282
 |  |  |  |  |  |  |  | 184 | A283
 |  |  |  |  |  |  |  | 185 | A284
 |  |  |  |  |  |  |  | 186 | A285
 |  |  |  |  |  |  |  | 187 | A286
 |  |  |  |  |  |  |  | 188 | A287
 |  |  |  |  |  |  |  | 189 | A288
 |  |  |  |  |  |  |  | 190 | A289
 |  |  |  |  |  |  |  | 191 | A290
 |  |  |  |  |  |  |  | 192 | A291
 |  |  |  |  |  |  |  | 193 | A292
 |  |  |  |  |  |  |  | 194 | A293
 |  |  |  |  |  |  |  | 195 | A294
 |  |  |  |  |  |  |  | 196 | A295
 |  |  |  |  |  |  |  | 197 | A296
 |  |  |  |  |  |  |  | 198 | A297
 |  |  |  |  |  |  |  | 199 | A298
 |  |  |  |  |  |  |  | 200 | A299
 |  |  |  |  |  |  |  | 201 | A300
 |  |  |  |  |  |  |  | 202 | A301
 |  |  |  |  |  |  |  | 203 | A302
 |  |  |  |  |  |  |  | 204 | A303
 |  |  |  |  |  |  |  | 205 | A304
 |  |  |  |  |  |  |  | 206 | A305
 |  |  |  |  |  |  |  | 207 | A306
 |  |  |  |  |  |  |  | 208 | A307
 |  |  |  |  |  |  |  | 209 | A308
 |  |  |  |  |  |  |  | 210 | A309
 |  |  |  |  |  |  |  | 211 | A310
 |  |  |  |  |  |  |  | 212 | A311
 |  |  |  |  |  |  |  | 213 | A312
 |  |  |  |  |  |  |  | 214 | A313
 |  |  |  |  |  |  |  | 215 | A314
 |  |  |  |  |  |  |  | 216 | A315
 |  |  |  |  |  |  |  | 217 | A316
 |  |  |  |  |  |  |  | 218 | A317
 |  |  |  |  |  |  |  | 219 | A318
 |  |  |  |  |  |  |  | 220 | A319
 |  |  |  |  |  |  |  | 221 | A320
 |  |  |  |  |  |  |  | 222 | A321
 |  |  |  |  |  |  |  | 223 | A322
 |  |  |  |  |  |  |  | 224 | A323
 |  |  |  |  |  |  |  | 225 | A324
 |  |  |  |  |  |  |  | 226 | A325
 |  |  |  |  |  |  |  | 227 | A326
 |  |  |  |  |  |  |  | 228 | A327
 |  |  |  |  |  |  |  | 229 | A328
 |  |  |  |  |  |  |  | 230 | A329
 |  |  |  |  |  |  |  | 231 | A330
 |  |  |  |  |  |  |  | 232 | A331
 |  |  |  |  |  |  |  | 233 | A332
 |  |  |  |  |  |  |  | 234 | A333
 |  |  |  |  |  |  |  | 235 | A334
 |  |  |  |  |  |  |  | 236 | A335
 |  |  |  |  |  |  |  | 237 | A336
 |  |  |  |  |  |  |  | 238 | A337
 |  |  |  |  |  |  |  | 239 | A338
 |  |  |  |  |  |  |  | 240 | A339
 |  |  |  |  |  |  |  | 241 | A340
 |  |  |  |  |  |  |  | 242 | A341
 |  |  |  |  |  |  |  | 243 | A342
 |  |  |  |  |  |  |  | 244 | A343
 |  |  |  |  |  |  |  | 245 | A344
 |  |  |  |  |  |  |  | 246 | A345
 |  |  |  |  |  |  |  | 247 | A346
 |  |  |  |  |  |  |  | 248 | A347
 |  |  |  |  |  |  |  | 249 | A348
 |  |  |  |  |  |  |  | 250 | A349
 |  |  |  |  |  |  |  | 251 | A350
 |  |  |  |  |  |  |  | 252 | A351
 |  |  |  |  |  |  |  | 253 | A352
 |  |  |  |  |  |  |  | 254 | A353
 |  |  |  |  |  |  |  | 255 | A354
 |  |  |  |  |  |  |  | 256 | A355
 |  |  |  |  |  |  |  | 257 | A356
 |  |  |  |  |  |  |  | 258 | A357
 |  |  |  |  |  |  |  | 259 | A358
 |  |  |  |  |  |  |  | 260 | A359
 |  |  |  |  |  |  |  | 261 | A360
 |  |  |  |  |  |  |  | 262 | A361
 |  |  |  |  |  |  |  | 263 | A362
 |  |  |  |  |  |  |  | 264 | A363
 |  |  |  |  |  |  |  | 265 | A364
 |  |  |  |  |  |  |  | 266 | A365
 |  |  |  |  |  |  |  | 267 | A366
 |  |  |  |  |  |  |  | 268 | A367
 |  |  |  |  |  |  |  | 269 | A368
 |  |  |  |  |  |  |  | 270 | A369
 |  |  |  |  |  |  |  | 271 | A370
 |  |  |  |  |  |  |  | 272 | A371
 |  |  |  |  |  |  |  | 273 | A372
 |  |  |  |  |  |  |  | 274 | A373
 |  |  |  |  |  |  |  | 275 | A374
 |  |  |  |  |  |  |  | 276 | A375
 |  |  |  |  |  |  |  | 277 | A376
 |  |  |  |  |  |  |  | 278 | A377
 |  |  |  |  |  |  |  | 279 | A378
 |  |  |  |  |  |  |  | 280 | A379
 |  |  |  |  |  |  |  | 281 | A380
 |  |  |  |  |  |  |  | 282 | A381
 |  |  |  |  |  |  |  | 283 | A382
 |  |  |  |  |  |  |  | 284 | A383
 |  |  |  |  |  |  |  | 285 | A384
 |  |  |  |  |  |  |  | 286 | A385
 |  |  |  |  |  |  |  | 287 | A386
 |  |  |  |  |  |  |  | 288 | A387
 |  |  |  |  |  |  |  | 289 | A388
 |  |  |  |  |  |  |  | 290 | A389
 |  |  |  |  |  |  |  | 291 | A390
 |  |  |  |  |  |  |  | 292 | A391
 |  |  |  |  |  |  |  | 293 | A392
 |  |  |  |  |  |  |  | 294 | A393
 |  |  |  |  |  |  |  | 295 | A394
 |  |  |  |  |  |  |  | 296 | A395
 |  |  |  |  |  |  |  | 297 | A396
 |  |  |  |  |  |  |  | 298 | A397
 |  |  |  |  |  |  |  | 299 | A398
 |  |  |  |  |  |  |  | 300 | A399
 |  |  |  |  |  |  |  | 301 | A400
 |  |  |  |  |  |  |  | 302 | A401
 |  |  |  |  |  |  |  | 303 | A402
 |  |  |  |  |  |  |  | 304 | A403
 |  |  |  |  |  |  |  | 305 | A404
 |  |  |  |  |  |  |  | 306 | A405
 |  |  |  |  |  |  |  | 307 | A406
 |  |  |  |  |  |  |  | 308 | A407
 |  |  |  |  |  |  |  | 309 | A408
 |  |  |  |  |  |  |  | 310 | A409
 |  |  |  |  |  |  |  | 311 | A410
 |  |  |  |  |  |  |  | 312 | A411
 |  |  |  |  |  |  |  | 313 | A412
 |  |  |  |  |  |  |  | 314 | A413
 |  |  |  |  |  |  |  | 315 | A414
 |  |  |  |  |  |  |  | 316 | A415
 |  |  |  |  |  |  |  | 317 | A416
 |  |  |  |  |  |  |  | 318 | A417
 |  |  |  |  |  |  |  | 319 | A418
 |  |  |  |  |  |  |  | 320 | A419
 |  |  |  |  |  |  |  | 321 | A420
 |  |  |  |  |  |  |  | 322 | A421
 |  |  |  |  |  |  |  | 323 | A422
 |  |  |  |  |  |  |  | 324 | A423
 |  |  |  |  |  |  |  | 325 | A424
 |  |  |  |  |  |  |  | 326 | A425
 |  |  |  |  |  |  |  | 327 | A426
 |  |  |  |  |  |  |  | 328 | A427
 |  |  |  |  |  |  |  | 329 | A428
 |  |  |  |  |  |  |  | 330 | A429
 |  |  |  |  |  |  |  | 331 | A430
 |  |  |  |  |  |  |  | 332 | A431
 |  |  |  |  |  |  |  | 333 | A432
 |  |  |  |  |  |  |  | 334 | A433
 |  |  |  |  |  |  |  | 335 | A434
 |  |  |  |  |  |  |  | 336 | A435
 |  |  |  |  |  |  |  | 337 | A436
 |  |  |  |  |  |  |  | 338 | A437
 |  |  |  |  |  |  |  | 339 | A438
 |  |  |  |  |  |  |  | 340 | A439
 |  |  |  |  |  |  |  | 341 | A440
 |  |  |  |  |  |  |  | 342 | A441
 |  |  |  |  |  |  |  | 343 | A442
 |  |  |  |  |  |  |  | 344 | A443
 |  |  |  |  |  |  |  | 345 | A444
 |  |  |  |  |  |  |  | 346 | A445
 |  |  |  |  |  |  |  | 347 | A446
 |  |  |  |  |  |  |  | 348 | A447
 |  |  |  |  |  |  |  | 349 | A448
 |  |  |  |  |  |  |  | 350 | A449
 |  |  |  |  |  |  |  | 351 | A450
 |  |  |  |  |  |  |  | 352 | A451
 |  |  |  |  |  |  |  | 353 | A452
 |  |  |  |  |  |  |  | 354 | A453
 |  |  |  |  |  |  |  | 355 | A454
 |  |  |  |  |  |  |  | 356 | A455