Bob -

Off the top of my head I can't think of any way that Excel would know the
underlying data has changed. If the data gets changed by virtue of manual
input, you could set up a worksheet change event on the data sheet that
refreshes the query. Alternatively, if you are importing a data file, and
you have automated that, you could add a query refresh to the end of the VBA
routine(s) that import the data file.

Beyond that I have no ideas.

"Bob" wrote:

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