Duke,
Thanks for your help! Is there a way I can create a dynamic query that
automatically updates every time I change the underlying data (rather than
the criteria)?
Bob


"Duke Carey" wrote:

The option Harlan gave you requires you to fill a range with formulas, and in
order to be sure you get EVERY SINGLE row, you must use a range of formulas
AT LEAST large enough for every possible row.

Alternatively, you can treat the data range as a database, use the
Data-Import External Data-New Database Query to create a dynamic query that
automatically updates every time you change the criteria. Excel takes care
of wiping out the previously retrieved values and updating with the values
meeting your newly entered criteria.


"Bob" wrote:

Yes, but I'm looking for an automatic way (i.e., using a built-in function or
UDF).


"Duke Carey" wrote:

Have you looked at Data-Filter-Advanced Filter?

"Bob" wrote:

Is there a way to use DGET or a UDF to extract multiple records that match
the same criteria? Using a macro would be my 3rd choice.
Thanks in advance for any help on this.
Bob