I have a cell on an excel spreadsheet that has different numbers entered into
it through a macro, I also run a query that imports data from a database into
the same excel spreadsheet, what I need to be able to do is filter the
database query so that it only shows the record with the number that matches
cell the value of cell D2.

Basically all I need to know is what I need to put into the "Query Wizard -
Filter Data" box so that It selects the value of cell D2:

I.e.

ExpenseRptName - equals - ? I need it to use the value of cell D2

Many Thanks

Windows XP Professional
Microsoft Office 2003

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob1866" wrote in message
...
I have a cell on an excel spreadsheet that has different numbers entered
into
it through a macro, I also run a query that imports data from a database
into
the same excel spreadsheet, what I need to be able to do is filter the
database query so that it only shows the record with the number that
matches
cell the value of cell D2.

Basically all I need to know is what I need to put into the "Query
Wizard -
Filter Data" box so that It selects the value of cell D2:

I.e.

ExpenseRptName - equals - ? I need it to use the value of cell D2

Many Thanks

Windows XP Professional
Microsoft Office 2003