Hid Columns based on ListBox Selection

Hello,

I am not sure if this has been answered before. I have been searching the forum and haven't found something that quite fits this situation. I can't help but wonder if there is an easy way to do this but have been hitting a brick wall. Mostly due to my limited knowledge of VB. I am familiar with programming basics, but do not know the syntax very well.

I have a matrix that contains a header row, 20 rows, and columns A through CL. I want to have only the columns that apply to the selected rows appear (empty ones are hidden)

My overall vision is this:

1. user opens the file (or runs a macro afterward)
2. a listbox appears showing the products listed in Column A
3. user the selects the product(s) he/she is working with
4. based on that selection, all other rows are hidden
5. Once the rows are hidden, or whicever makes more programatic sense, cloumns that are empty for all remaining rows are hidden.

Final Result:

The user is left with only the columns that apply to the selected rows.

I have attached my spreadsheet for reference.

Any help is greatly appreciated, and I'm available to answer questions if the above items seem unclear.

Upload Template Matrix-excelforum.xlsx