Hide Suggestion

[Harley78]

I have a worksheet that contains over 15k rows, each row, in column AK has an input of X-123, x123, 123, ENVEL, ROL, WPL-503, etc. there are a total of 20 different inputs. These inputs are found on another file and inputted from with a Vlookup formula.

I tried advanced filter, but it is limited and thought, if I have a command button that opens a userform then I can select which ones I want to be hidden.

I don't know exactly if I should use a checkbox, listbox, combo box ect. or if you can suggestion an alternative.

Thanks

Bill

 

[Harley78]

I seriously think there is something to do with the formatting of the cells, I tried exactly using a new form without any problems with a brand new workbook. I just can't determine how to compare formats between each file.

Thanks again so much for the help and patience

Bill