hi,

attached is a sample file.

I would like to create a msg box to ask for the search word,

the search should be for Occupation Description & primary activities,

search should be restricted to occupation description & primary activities column only

the results should appear on a seperate worksheet, and then create a hyperlink to the relevant , in the newly created worksheet

please help