Filtered results and printing

[glassjo]

Hello everyone:

I have a question about excel that I am sure someone here ca
answer....

I have a table set up with a lot of data, and that uses autofilters t
choose which data to show based on various criteria. I know that
can print the filtered result quite easily by setting the filters t
the criteria I want, and then printing.

I would like to make this easier for other people in my company, wh
are not so familiar with the use of filters in excel. Specifically,
would like to set up a separate print page (i.e. - separate worksheet i
the front) that contains a number of drop down lists. The drop dow
lists are set up using the Data...Validation commands, and correspon
to the headers at the top of my list.

I would like to build a macro (or find a function) that takes th
results of the Drop-Down Lists and then (i) automatically transfer
them to become the "filtered results"- (i.e. - resets the filters base
on the results of the drop down list) and then prints out the result fo
the user. The users then don't have to touch they filters; all the
have to do is make their choices on the Drop Down lists.

I guess a key would be to set the filters automatically using th
results of the DropDown list.

Can anyone help me on this? Feel free to email me a
(e-mail address removed).

Thanks,

John

(e-mail address removed)

 

[Guest]

I'm not sure I am interpreting your need correctly, but if I am you can do
this;

1- Set the AutoFilter for one set of criteria

2- Go To View>Custom Views, click Add & type in a descriptive name for the
view

3- Do this for each set of criteria

You can also add the Custom Views drop down list (from
Tools>Customize--Commands-Views) to a toolbar or create a custom menu of
views for the users to pick from. They can also switch directly from one view
dto any other without having to Show All records. (Suggestion: If all records
need to be shown, create a view for that too.)

HTH |:>)