Automatic macro trigger

First time posting here and I'm relatively new to Excel in general. I created a macro that hides rows where every cell in that row lacks a numerical value. My macro is,

Sub Hide()
For Each Cell In Range("AB14:AB25")
If Cell.Value = "Hide" Then
Cell.EntireRow.Hidden = True
Else
Cell.EntireRow.Hidden = False
End If
Next Cell
End Sub

The range "AB14:AB25" refers to a column with an if statement that shoots out the value "hide" if each cell in that column is "N/A." The macro works but requires you to continuously and manually hit the macro button "Hide" whenever you change the relevant variable from the drop down menu (the table populates with data based on the variable you select from the drop down menu). So my question is, how do I make it so that the macro automatically triggers whenever you change or select a different variable from the drop down menu? Thanks in advance!

the automated macro can be triggered by ANY cell change or a selected range of cells

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

For Each Cell In Range("AB14:AB25")
If Cell.Value = "Hide" Then
Cell.EntireRow.Hidden = True
Else
Cell.EntireRow.Hidden = False
End If
Next Cell
End Sub

you can then restrict its triggering urge by testing target.row or target.column

Thank you for the help, and I'm sure that these macros work. The only issue I'm having now is that I don't know where to put these codes. I have 1 module with two codes:

Sub Hide()
For Each Cell In Range("AB14:AB25")
If Cell.Value = "Hide" Then
Cell.EntireRow.Hidden = True
Else
Cell.EntireRow.Hidden = False
End If
Next Cell
End Sub

Sub Show()
Range("AB14:AB26").EntireRow.Hidden = False
End Sub

If I add the macros that you guys suggested to this module, and hit run, nothing happens. If I go to the worksheet titled "Universal table," hit "view code," copy the code onto there and run it, nothing happens either. Again, this is my first time working with VBA so I'm probably missing the obvious. In short, where do I put the codes that you kind gentleman have given me? Thanks again!

I apologize for not including the code tags. Always forget to read the rules before I enter a new forum. Either way, it's still not working for me . Whenever I change a variable from the drop down menu, the rows with solely N/A values remain unless I manually trigger the "hide" macro. I know that I'm close, but can't get there... Thanks though.

Yeah, it will hide the row. My problem is that I need the macro to trigger whenever the value in cells Ab14:Ab25 change from "Hide" to "Show" based on variable changes from the drop down menu. In other words, I don't want to touch anything manually; I want the rows that lack numerical values to automatically hide whenever I change a variable from the dropdown menu. I want the rows that lack numerical values with one variable from the dropdown menu to reappear whenever I choose a variable (again, from the drop down menu) that populates that row with numerical values. I'm not sure If I'm being entirely clear..

I'm not allowed to share my workbook because it contains client related data and personal information.

So essentially, I have a 13x11 table where the columns are sorted by data source, region, source table, number of respondents, weight of consideration, standard deviation, 25th percentile, median, mean, 75th percentile and 90th percentile. The drop down menu allows you to populate this data based on region, specialty and metric. So for example, when you change the specialty from, say, Cardiologist to Rheumatologist, some of the rows that were populated with numerical values for the former no longer exist for the latter. Here's a specific example: there may not be any information for cardiologist legal fees in the Midwest region, but there may be information for rheumatologist legal fees in that region. I need that row to hide when I click on cardiologist, and then I need it to reemerge, automatically, when I change the specialty to rheumatology.

I'm attempting to trigger my macro based on the if statements in column AB. When the row lacks numerical values, the if statement spits out "Hide," when it has values, it spits out "show." Thanks again. Hope this is somewhat clear.

It's a listbox tied to three pivot tables and to 3 cells which refer to the number corresponding to the individual values in each pivot table. The three cells are then combined to create a master reference cell from which all other cells draw their values via vlookup.

You are a hero. Thank you!