I have columns on Sheet 1 with a filters and I want a way to make a list on Sheet 2 of each item (with out repeating) that is in the corresponding column on sheet 1.

This will be programmed in a userform to create the list when the form is loaded.

The end result being this:
CopyFilterList.png

This is an example and there could be up to 50 or more options.

Thanks!