What it does
Shows an auto-complete search form to look for custom lists within your library that can be quickly inserted in the active cell and below.

When to use it
When you want to search for a value using auto-complete (potentially not knowing the exact value you’re looking for) and insert the entire custom list in the active cell and below.

Why to use it
It’s a quick way to insert a custom list.  If you leverage many custom lists or use them often, this is a really easy way to insert them.

Default shortcut
None

Other Details

• Category: Data / Content
• Difficulty: 2/5
• Usage/frequency: 2/5
• Automation factor: 3/5 (estimated 30 seconds saved each time used)
• Type: Shortcut
• Date added: 9/11/2023
• Tags: search, auto complete, custom lists

Related Macros
Bulk Edit Custom Lists

Other Articles
None

None

Prerequisites
None

Instructions
Run the Search Custom Lists macro.  It will prompt you with a search form offering you suggestions of values as you type.  Use the up and down arrows (or click with the mouse) to select a suggested value to apply.  Press Enter to insert the entire custom list to active cell and below.

Note that this may overwrite values in cells below the active cell.  Ensure that the cells are clear or you don’t mind them overwriting before applying custom list values.