auto filtering

[max1565]

I have a database in excel 2000. I would like to filter the database using the value found in worksheets("criteria&quot.range("a4&quot.

can someone tell me how to do this?

thanks

 

[xlbo]

const Fld = 1
Crit1 = sheets("Criteria&quot.range("A4&quot.text
Sheets("SheetName&quot.range("A1:M1000&quot.autofilter field:= Fld, criteria1:= Crit1

change the range to fit your "database" - please note it is not really a database - more of a flat table. Change "sheetname" to reflect the name of the sheet you are trying to filter

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244