Search entire workbook except 1 tab

Hi all,

I am back with an adaptation of my initial issue about a search macro where it searches all worksheets for information and displays it including the hyperlinks on the main page. This works brilliantly however after some feedback from its users, they would like an index of the topics to help them search more intelligently.

So i have made an attempt by having a topics worksheet which pulls all entries from the multiple worksheets into 1 (very basic approach if honest) then simply filter out the blanks. However since adding this worksheet, info on this sheet is now included in the search results and technically duplicates the information but as its a formula displays #REF!. So what I am hoping for is one of two things. 1: a better way to display all topics in the workbook so it doesnt not affect the results or adaptation of the below code to search all worksheets except the one named Topics.

Below is the code and a sample workbook. Any help that you can provide would be great.

Thanks

Stuart

Please Login or Register  to view this content.

Thanks John this works a treat!

I will mark as Solved.

Thanks