I have a workbook where I perform an advanced filter and from there create a dropdown list. Now I need to have the user select an item from the dropdown list. This selection then needs to be "read" and use this selection to copy the specific items to another workbook. Right now, the only stumbling block for me is how to take the selected item in the dropdown and assign it to the variable name.

Any help in the right direction is appreciated.

Thanks.