I have a large 2 column data set, divided into about 15 categories, which I have assigned a name (general, widgets, etc.). One column is a code number, the other the detailed description. This data is on a hidden sheet.

On another sheet, I have a drop down list in cell A4 with each of these categories. When the user selects General, Widgets or whatever from this list, I would like the data of each named set to populate starting in cell B4.

The range of each category is dynamic, anywhere from 1 item to a potential 1000 items.

Is this even possible?

Thanks in advance!