I'd like a separate worksheet within a workbook to display desired results
only. For example:

All data is contained in Sheet1
Sheet2 displays only rows from Sheet1 where column H = 'yes', without
leaving a bunch of blank rows corresponding to undesireable results.

Thanks