What I'd like is a Dropdown list to include all the items in the top range in the attached followed by the list of data in the second range. I can't sort the two lists together since I want the second list to be at the bottom of the list showing up in the dropdown list.
Thanks for your help,
RR
|