Macro or VBA help

[datadummy]

I am new to writing macros and am trying to write one that looks at column H and looks for the response of No and then takes that whole row and moves it to a new tab and then repeats that step for the remainder of the data. Any help would be appreciated or pointers on writing macros.

 

[Joe4]

What about the possibility of using Filters?
With Advanced Filters, you can copy the results to a different sheet.

See: https://www.contextures.com/xladvfilter01.html