Search a column for a value, hide rows that do not contain that value

[Blanchetdb]

Hi

So I am looking to have a code that will search thru column P (range P2:P2000); search for the name of a person ex. Jane Doe (value in cell C6). If found, the corresponding row would be visible but rows that do have than name within that column, the row would be hidden

So I only want to be able to see the rows that contain the name entered in cell C6

any help would be appreciated

thank you
Dan

 

[Blanchetdb]

How about:

Sub HideRows()
    Range("P7:P2000").AutoFilter Field:=1, Criteria1:=Range("C6").Value
End Sub

okay ... that worked but I have a "RESET" button that resets the page to its original view - all rows are visible....that no longer works

 

[johnnyL]

Have your 'RESET' button point to the following:

Sub ResetSheetFilter()
  If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
End Sub

 

[Peter_SSs]

okay ... that worked

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[johnnyL]

Always glad to help.