Home

Data validation lists

%3CLINGO-SUB%20id%3D%22lingo-sub-525772%22%20slang%3D%22en-US%22%3EData%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525772%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20data%20validation%20to%20select%20cutomers%20via%20drop%20down%20list%20from%20a%20%22customers%22%20table.%20I%20would%20like%20to%20be%20able%20to%20add%20a%20new%20customer%20by%20typing%20in%20the%20name%20in%20the%20drop%20down%20list%20dialogue%20instead%20of%20going%20to%20the%20table%20to%20make%20a%20separate%20entry%20(that's%20what%20happens%20when%20I%20use%20AirTable%2C%20the%20option%20to%20add%20the%20item%20shows%20up%20when%20I%20start%20typing).%20Can%20it%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-525772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527213%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527213%22%20slang%3D%22en-US%22%3EYou%20may%20follow%20the%20instructions%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50fx%2Fhome%2Fexcel-data-validation-with-on-the-fly-update-without-vba%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50fx%2Fhome%2Fexcel-data-validation-with-on-the-fly-update-without-vba%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527237%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527237%22%20slang%3D%22en-US%22%3EThanks!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
pamborides
New Contributor

I am using data validation to select cutomers via drop down list from a "customers" table. I would like to be able to add a new customer by typing in the name in the drop down list dialogue instead of going to the table to make a separate entry (that's what happens when I use AirTable, the option to add the item shows up when I start typing). Can it be done?

2 Replies
Thanks!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies