Dear Excel Experts:

I have many validation lists which source can change frequently. How do I
automatically update the validation lists every time the sources change?

I got some lead from www.contextures.com (see below). But, it only helps
when I have one validation list. Meanwhile, I have many lists.

DV0022 - Update Validation Selections -- If you change an item in a data
validation source list, the worksheet may show previously selected items.
Event code can update the worksheet when you update the source list.
DataValUpdate.zip 10kb Updated 07-Sep-11

Thanks in advance for your help. Hope I get a response from one of you.

Cheers,

Lusiana