Help with creating VBA to filter validation list

Originally Posted by Palmetto

Try this code in the worksheet module.

There are some changes you need to make to the worksheet.
The values in the Joist Size list are all numbers formatted as text. Always use General Format or a specific number format for numbers - but never use Text format.

A helper column is needed (can be hidden), to designate rows relative to joist size. I've chosen column-A. you can use another column, but must revise the code if so.

Palmetto, thank you very much for your help! I changed the text for my Joists list to General, as you suggested.

I did have a helper column in B but I was using an "IF" formula to display it. I guess, I wasn't thinking simplistic, :-). So I changed the code that you gave me to "B" and I copied your values in Column A to my Column B.

Now, if I want to use the same situation to hide columns, can I just change any of the references of Row to Column? I'm going to try it now to see...wish me luck! lol

I appreciate your help!