I currently have a report that uses a macro to generate business branch statistics in several rows in Excel based off the branch that is selected in cell A1 on my spreadsheet, using a drop down list.

Currently each row is used for every branch and I want to know if there is a way I can create a custom view in Excel where I can have only the rows with data specific to that branch selected in cell A1 appear. Since each business branch may look at different statistics in each row I need a more customized report.

I am aware of the custom view toolbar that can be used to select specific views but I am trying to automate my report so that I just have to select the business branch from my drop down list in A1 and run the macro in order to get the rows of statistics that are important to that branch.

Please let me know if you have any thoughts...Thanks!