Searching within excel

[soregan]

Hello,

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

Basically this document is HUGE. What I want to do is make a searc
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 h
wants me to use this format so everyone can use it.

can anyone help!

 

[Mike Fogleman]

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