Hello,
I used DV0022 in the below link to automatically update a drop-down list in
worksheet 2 whenever I change the source list in worksheet 1.

http://www.contextures.com/excelfiles.html

However, now I have 2 lists - one in worksheet 2 and one in worksheet 3 -
which both use the same validation source list. I tried to adapt the macro,
but it only updates the second list, not both. Is there a way to update more
than one list?

thank you.
Jen