You can still use the autofilter function in a macro so that "anyone" can
use it. First collect the search criteria from the user with input boxes,
userform, or something, and then use those for your Filter criteria in the
macro.
Mike F
"soregan " wrote in message
...
Hello,

Ive been given work by my boss and he has given me the task of
arranging a sheet for individual needs.

Basically this document is HUGE. What I want to do is make a search
base using VBA refining the search for department, job no. etc.

yes, it did cross my mind to us auto filter but for some reason he
wants me to use this format so everyone can use it.

can anyone help!?


---
Message posted from http://www.ExcelForum.com/