Assistance with VBA and drop down list

[Biffa]

Hello everyone,

My apologies for making my first post a question without a proper introduction.

I'm Biffa and have gratefully browsed your forums and had valuable help in the past. Thank you all.

I have an excel document of which i hope to attach a simplified version to this thread.
It normally runs some VBA, and I recently altered it so that when we fill a form in (not attached) it automatically has a lot of data filled in (in columns M:AE). This seemed easier than clicking dozens of drop downs for every entry.

The ECN database holds all the information. However, because I have auto filled a load of data, it shows up in columns M to AE.
These columns relate to different products e.g Columns M to AA relate to PRODUCT A
Columns AB to AC relate to PRODUCT B
Columns AD to AE relate to PRODUCT PLUS

I did manage to auto hide the columns, but couldnt get them to re-open.

I'd like to autohide them all the time. If a product is selected by filter in column D PRODUCT FAMILY i need it to show the corresponding columns for that product.

I hope i made this clear enough.

Thanks in advance
Biffa