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

01-16-2008, 06:30 PM

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

01-21-2008, 04:44 AM
hope this will help u


01-21-2008, 03:12 PM
thank you. could you please advise on a code, I would be searching on range from "C:D", 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