Solved: Find TExt in a column and give result from the next column

[vdeen]

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

[anandbohra]

hope this will help u

http://vbaexpress.com/kb/getarticle.php?kb_id=589

[vdeen]

thank you. could you please advise on a code, I would be searching on range from "C", and the search results appear on a seperate page, but I would like to differentiate, the results from Column C & D either by different colour highlights, or a third column to define the column heading