So I'm pretty new to VBA and I'm not entirely sure how to approach this. I'm working with an existing report and my boss doesn't want it transposed or changed from the current format. I have productivity metrics running down column B and C4:AO4 has the headers (names of different offices). I'm basically trying to simplify reading this huge report by only showing selected offices. I was thinking of creating a combo box that contains all the office names and then when selecting an office name it hides all other offices (or columns) and only shows the metrics of the selected office. I'm not sure where to start.