Newbie Excel question (filtering)

[Asolandri]

I have a workbook with 2 worksheets, the first of which contains a data entry part along with some control data, and the second of which contains multiple rows of data based on the first worksheet which is to be printed.

Question is, how do I automatically filter the rows on the second worksheet based on a value from the first worksheet? Yes I know I can use auto-filter, but the boss doesn't want to have to do that. Thanks in advance.

 

[SkipVought]

Hi,

I don't want it to rain. Guess what? I have no say, and neither does the president!

But there is another possibility using MS Query (provided that the data on the other sheet is a TABLE) via Data/Get External Data/New Database Query -- Excel Files -- YOUR WORKBOOK -- YOUR SHEET.....

You set up the query criteria as a Parameter Query, meaning that the VALUE in the criteria (the value that you boss wants to trigger the filter) will be something like
[tt]
[What value?]
[/tt]
The BRACKETS define that a VALUE will be provided at the time that the query is executed.

Then you return the query results to Excel, you will have the opprtunity to specify that the VALUE is in a CELL on the worksheet. There's even a checkbox to fire the query each time the value changes.

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]