Data Validation Auto Complete Data Entry

egifford

New Member
Joined
Oct 11, 2006
Messages
1
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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,114,671
Messages
5,549,344
Members
410,910
Latest member
DessertDiva
Top