User Form to Search/Display multiple criteria on a seperate sheet with use of hyperlinks

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

Sorry just to add as a post thought, the search criteria might not be exact. For example if someone typed in 'Hydrotesting' in the scope field it would still display results for 'Pig Trials & Hydrotesting'

Any takers on this? :P

I've attached an example to show you the lay out of the library.

Bump - Still trying to Resolve this, any advice guys?

Hey, can anyone help with this one?