Combination Search Criteria

[wherdzik]

I currently have this code to filter for the name of the employee. This filter works great but this spreadsheet spans out far all the way to column GB. It has different sections in there. So when I filter for the employee name it takes me to the line. but is there a way to do a combo search where I can type in the employee name and then lets say I type in also Call Pay, or Medical directorship and it takes me to the section where this matching text string starts?


Is there such a possiblity?

Please Login or Register  to view this content.

[torachan]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[wherdzik]

I apologize. Please see attached.

I guess this is what I was thinking. When I type in the quick search box in cell c5 and type "Luke Proctoring Hours" it would take me to line 38 and to column AR cell 38.

I hope I am explaining that correctly.

Thank you.

[Bo_Ry]

Maybe try

Please Login or Register  to view this content.

[wherdzik]

Thank you Bo_Ry. You are always so very helpful to me. Thanks for taking the time to help...it really helps me quite a bit when you offer your help. You are very kind.

[wherdzik]

Bo_Ry is it possible to have both of the searches on one page. The code you created would point to cell F5 and the code that I posted would be in C5. I know you cannot have 2 "Private Sub Worksheet_Change(ByVal Target As Range)" on one page but I dont know how to put both of them on one module. Is it possible?

[Bo_Ry]

Add Elesif

Please Login or Register  to view this content.

[wherdzik]

Thank you again Bo_RY!