What it does
Uses a settings sheet (Bulk_Edit_Custom_Lists) to add, edit, and delete custom lists in one bulk step.

When to use it
When you want to quickly make several updates to one or more custom lists in Excel.

Why to use it
It’s a quick and easy way to copy and paste several lists you can set to custom lists in one bulk step.

Default shortcut
None

Other Details

• Category: Data / Content
• Difficulty: 3/5
• Usage/frequency: 1/5
• Automation factor: 4/5 (estimated 180 seconds saved each time used)
• Type: Bulk
• Date added: 9/11/2023
• Tags: custom lists, bulk

Related Macros
Search Custom Lists

Other Articles
None

None

Prerequisites
Identify the custom lists you want to add, update, and/or delete.

Instructions
After you have identified the custom lists you want to add, update, or delete, run the Bulk Edit Custom Lists macro.  The first time you run it, it will create a sheet called Bulk_Edit_Custom_Lists.  This is where you’ll add the list number and the list items.  Note that you can’t change the first four default Excel lists, so the first list # must be 5 and up.  After filling in the fields, run the Bulk Edit Custom Lists macro again to process the sheet contents.  These are the fields in the Bulk_Edit_Custom_Lists sheet that you’ll want to fill in:

• Column A – List # (required): enter the list number to add or update (5 or greater).
• Column B – List item (required) – enter the list item.  Note that each list # must have at least two list items.

There is no need to enter add, edit, or delete – simply list the list # and items for each list you’d like to have in your custom list library.  To remove a list, simply clear it from the Bulk_Edit_Custom_Lists sheet.