Seach enitre workbook and display entries Macro

[stuartgood24]

Hi all,

Apologies for another newbie post. I am learning the wonderful world of VBA and I am hoping for someone to help me with the below code. I found it in an earlier post and I am having trouble with developing it further to fit my needs. I am creating a search tool that allows the user to input a string of Characters, press search and it then displays each entry and its corresponding date contained within the whole workbook containing that string. This is so I can find the dates of when a topic was communicated and the most recent version of this. For example I could post a topic about compliance, then 2 months later an update will come out on the same topic. I would need to be able to search all updates on compliance and the most recent one to show at the top with older entries after. I would also like if possible close matches to load below. I know this is a big ask but if possible then great. I have attached a sample workbook for reference. Any help would be gratefully recieved.

The code I have started with is as follows: When typing in a topic to search it does not always find it unless I either retype it prior to searching or follow the workaround as mentioned in the post by F2 select all and paste into the search box. So I am hoping someone could help me as time frames are also quite short if honest.

Thanks in advance as I know I am asking a lot.

Stuart
Search Sample2.xls

Please Login or Register  to view this content.

[tigeravatar]

stuartgood24,

Welcome to the forum!
Give this a try:

Please Login or Register  to view this content.

[nilem]

I'm a little late
Let it be a slightly different version

Please Login or Register  to view this content.

[stuartgood24]

Thanks to you both Tigaravatr and Nilem!

Both of these work great! way beyond me!

Is there any possibility of this also pulling the date through if the cell contains the search string and other characters also? For example Topic 1 would be the search criteria and it would pull all cells with Topic 1 through including say "Topic 1 - update" or would it have to be an exact search?

Also the dates on the month tabs are hyperlinked to the document that was sent out allowing the user to open the doc from within the workbook. Is there anyway of pulling the hyperlink through also? Just trying to keep the user on one sheet if possible.

Thanks again for your time already spent on this its really appreciated!

Stuart

[tigeravatar]

Stuart,

Updated code to preserve hyperlinks and return partial matches. Note that searching for "Topic 1" will find "Topic 1 - update" correctly, and will not find "Topic 11"

Please Login or Register  to view this content.

[stuartgood24]

Wow thank you so much! this works a dream! Now comes the fun part of picking it apart to learn what each part does! So much easier when you see it in front of you!

I will mark the thread as resolved and thanks once again!

Stuart

[tigeravatar]

You're very welcome