I am building an inventory spreadsheet for a school district. I have created Data Validation List tables for data entry, but this allows for drop down box selection only. Is it possible to do an autocomplete after typing the first few letters of a given list table without having to go to the drop down box? Each table is a single array and each table is less than 1500 records. Inventory tables are classroom type, software titles, curriculum areas, etc. I am trying to create ease of data entry and data consistancy.
Thank you!
Ed
Thank you!
Ed