My client likes these drop downs (using data, then validation, then list),
but I notice that, if the list you want to use is on another worksheet, you
can't do it. Since this worksheet will be replicated 100s of times in the
workbook, I really don't want to have to have a copy of the list on every
such sheet. Is there some other similar way to have a pre-populated set of
choices for a cell, where the choices come from another worksheet? Also, I
have noticed that, when my biggest spreadsheets crash and go into repair
mode, it is always the data validation drop downs that get wiped out,
sometimes all the formatting, but not always, but always these drop downs
get wiped out. So, perhaps there should be (and is) a better way/

Thanks for any help!
Dean