Good Afternoon All,

I was looking to create a user form for searching multiple criteria and displaying the matching results.

The first worksheet 'Search' Will host this user form. All the data for the userform is stored on the second sheet 'Pipelines'

In pipelines Column A 'Client', Column B 'Project No.', Column C 'Scope', Column D 'Document No.' & Column E 'Document Title' (Which has a hyperlink embedded so when clicked will open up the corresponding document)

I'd like the User for to allow you to enter multiple criteria, any number of the 5 given fields. For example Client and Scope and it would then search the database and display all the matching documents with the ability to still click the hyperlink.

Is this possible to do with the hyperlink still working correctly?

My Visual Basic is very limited and I'd hate to try working on this for what would probably take weeks (for me :P) only to discover its not possible.

Any Help, Information or Advice would be greatly appreciated!

Many Thanks in advance!

R