Hide colums based on drop down list

Hi all

I have a sheet with a drop down list in cell B2. This contains Locations.

When a location is selected in the list, I want it to show only columns that have that location in row 6.

Can anyone help me - I've done a lot of searching, however most examples search all the information in the whole sheet, not just the one row.

Thanks in advance!


Anna

Great that works thanks! My only thing is that I have the location in a merged cell in the row (spans over 2 columns), I want both the columns to show, but it's just picking up the one?

Also - how would I do a clear all button? or show all?

Thanks again.... I had this working - and now it's not... I've attached the file. (I think?)

I understand how the columns can be unhidden, however this is for users with little to know knowledge of excel.

In the end I will be locking down the cells so they can enter information in only the 'Hour Meter readings'.

I've added an all to the Location drop down list, but haven't got the functionality sorted yet.

My end goal for this is so that each user can select their Location, and maybe then different paramaters too (hoist type). and then there will totals / averages columns just that add up the weekly hours for each fleet no depending on the paramaters that have been set.

Am I going about this the right way?

Thanks again for your time!

Thanks again Scottiex.

This is working great. However its working when both selection drop down boxes have a selection, but if the location (A3) is All, and then the second one A6 has a selection, it does not hide the columns.

It's possible there maybe a need to add in further search / display criterias to, how would I update the code so that any of the drop down boxes would change the displayed columns?

THanks again for your help with this.