I would like to set up a workbook with two worksheets:
- Sheet1 will have numerous rows of data
- Sheet2 will display only those rows from Sheet1 that meet a specified
condition, e.g. Column H in Sheet1='yes'
I'd like to accomplish this without displaying a bunch of blank rows that
don't meet the desired condition. Is there a formula or a way to do this?
Thanks