Automatically Hide Rows Based On Cell Ref

[ChrisO'Brien]

Hi,

I would like a page within my macro enabled workbook to automatically hide and unhide rows based on the cell reference within column C of each row.

Page Name "Pilot Log"

Possible text references within column C would be

"MA"
"SA"
"P3"
"P4"
"P5"

The rows I would like to hide / unhide automatically start at row 7 and continue down the sheet to row 43.

Row 6 is the row that displays "Date / Battery Set/ Remote Pilot/ Location / Task etc" and needs to be visible. Infact Rows 1-6 always need to be visible.

Cell Ref "M1" in my sheet is my control box and is a data list. I propose to click this and select say "MA" from a list. Doing so would hide all rows without "MA" in their column C.
Deleting it would show everything and selecting something else from the list would show only the rows with that specific reference.

Example:

Date	Battery Set	Remote Pilot	Crew Members	Location	Task	OSC	CA	Take off time	Land time	Flight Time
		MA
14-Aug-20	A	SA						16:53	17:05	12:31
	E	SA						17:08	17:21	13:48
	D	P1						17:58	18:13	15:33
12-Aug-20	A	P2					CA	14:45	14:59	14:21
	B	MA					CA	15:06	15:19	13:32
	C	MA					CA	15:21	15:29	8:25
31-Jul-11	A	MA					CA	08:54	09:07	13:42
	B	MA					CA	09:22	09:34	12:59

Thanks In Advance for any help, I hope all is clear.

 

[ChrisO'Brien]

Column K is the final column of data

The range that needs sorting as such is A7:K43

 

[Fluff]

OK, try

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "M1" Then
      If Target.Value = "" Then
         Range("A6:K6").AutoFilter 3
      Else
         Range("A6:K6").AutoFilter 3, Target.Value
      End If
   End If
End Sub

 

[ChrisO'Brien]

That Works Perfectly. THANKS

 

[Fluff]

You're welcome & thanks for the feedback.