Concatenate validation lists to same sheet.

Hello.

I have used this code before to combine two validation lists.

Hopefully, this will be easy. Now, instead of putting the combined list on a separate sheet, I'd like it in the Z column of the "Lists" sheet (the sheet the separate lists are on.). And instead of a button, some kind of way where if I add/remove entries to either of the separate lists ("VendCity" and "CustComb"), the combined list ("MyBigList") automatically grows and shrinks so it is always accurate.

Here's the code:

Please Login or Register  to view this content.

Any ideas?

Respectfully,

Lost