access-type query in excel 2007

G

Guest

Is there a way of filtering in excel 2007 where I can save that filter, give
it a name, and use it again, similar to a query in access?
 
D

Dave F

YOu could record a macro in which you perform the filter and then
attach that macro to a button...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query - Filtering all dates greater than the current date 1
Access #Error & Excel Pivot 0
Rename imported MS Access field names 1
Excel 2007 compatibility issue - speed between cells 2
Opening excel 2010 spreadsheet from Access 4
edit query in Escel 2007 pulled from Access? 1
No Results returned from Access query 3
Using MS Query with Excel and Access 2007 3

Top