I have a table that has a data validation drop-down list in column G and I am trying to figure out to create a macro that will auto-hide a row when a specific item from that list is selected. Does anyone know if this is possible, and if so, how to set it up?