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!


--
jhovey
------------------------------------------------------------------------
jhovey's Profile: http://www.excelforum.com/member.php...o&userid=35473
View this thread: http://www.excelforum.com/showthread...hreadid=552516