P.S. Sorry about the duplicate posts about the same subject. The other two
didn't show up in the newsgroup for a long time after I initially posted them
late last night.

"Marie" wrote:

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