The list can either be a set of values that you enter separated by comas or
it can be a link to a range of cells. In order to link to a range of cells
that is on a different sheet that range must be a named range. Additionally
if you wnat the list to shrink and grow then you nned to link the list to a
dynamic named range. Here is a link to dynamic named ranges.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.