Hi, All,
Sorry, but my brain refuses to work - again. To validate data one can:
1. Manually highlight the range to be validated, and fill the Data Validation prompts, or
2. Create a table and then define a named range within the table and fill in the prompts.
However, when I was using Excel 2003 I seem to remember creating a dynamic named range (something similar to a table named range) and using that as the data to be validated.
Unfortunately I cannot remember, or figure out despite lots of searching, how to use a dynamic named range as the input. Creating the range is fine, but using it, apparently, is beyond me. I know I could, and probably should, and probably will, use the table method, but this is really bugging me now. Please take pity on a stupid old man and remind me how to do it.
Many thanks.