Help needed with if statement

[Tom James]

I have a spreadsheet that tracks tasks with drop down boxes that include the values B, G ,Y, A, and N/A. The number of each status is calculated at the top of the sheet through a count if statement.

I am hoping to add in another drop down box above each section using the same as the above. So you can select N/A for a team. When selecting the N/A for the team I need a section of rows to also be set to N/A and hide the lines.

I am struggling to understand what I should be adding to set the cells to N/A - Please can someone help.

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("G13") = "N/A" Then

Set cells E14-E22 TO "N/A" and hide rows 14 - 22

    'Range("14:22").EntireRow.Hidden = True'


    Else
    Range("14:22").EntireRow.Hidden = False

End If

End Sub

[#2]

Trigger cells are below

Target Trigger Cell G13  -- This is the cell that the drop box will be in 
Cell Range Row 14 - 22 -- This is the rows that selecting N/A from the dropbox will hide and set the cell in Col E to "N/A" e.g E14 - E22 will have the text N/A and the row will be hidden from view. 

Target Trigger Cell G23
Cell Range Row 24

Target Trigger Cell g 25
Cell Range Row 26 - 27

Target Trigger Cell G28
Cell Range Row 29 - 30

Target Trigger Cell G31
Cell Range Row 32 - 34

Target Trigger Cell G35
Cell Range Row 36 - 38

Target Trigger Cell G39
Cell Range Row 30 - 41

Target Trigger Cell G42
Cell Range Row 43 - 44

Target Trigger Cell G45
Cell Range Row 46 - 49

Target Trigger Cell G50
Cell Range Row 51 -54

Target Trigger Cell G55
Cell Range Row 56 - 57

Target Trigger Cell G58
Cell Range Row 59 - 61

Target Trigger Cell G62
Cell Range Row 63 - 68

Target Trigger Cell G69
Cell Range Row 70 - 83

Target Trigger Cell G84
Cell Range Row 85 - 87

Target Trigger Cell G88
Cell Range Row 89 - 97

Target Trigger Cell G98
Cell Range Row 99 - 104

Target Trigger Cell G105
Cell Range Row 106 - 111

Target Trigger Cell G112
Cell Range Row 113 - 115

Target Trigger Cell G116
Cell Range Row 117 - 118

Target Trigger Cell G119
Cell Range Row 120 - 124

Target Trigger Cell G125
Cell Range Row 126 - 128

Target Trigger Cell G129
Cell Range Row 130 - 137

Target Trigger Cell G138
Cell Range Row 139 - 145

Target Trigger Cell G146
Cell Range Row 147

[#3]

Tom-

Can you please attach a sample spreadsheet?  The solution you require isn't too difficult,  it would probably be easier to resolve if you could provide an example of your data representation.  I believe this is what you would like to do:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address = "$G$13" And Target.Value = "N/A" Then
        Range("E14:E22").Value = "N/A"
        Rows("14:22").EntireRow.Hidden = True
    ElseIf Target.Address = "$G$13" And Target.Value = "Some Other Value..." Then
    
        'Do some other stuff here.....
    
    End If

End Sub

[#4]

Hey Tom-

Just wanted to follow up and see if the code snippet provided was a good solution for you or if you may need additional assistance solving your issue?  Feel free to post back to this thread if you need clarification or have questions.