If I am creating a drop down list in Excel using Data Validation, can the
source part be located in another worksheet? I would like to put a
highighted range in the source box instead of typing in values/text. Also,
if I add items to the original list on the other worksheet or edit them in
any way, will my list box reflect this update?
Thanks!