Let's say that you want to bring over cells between A2 and G50 from
Sheet1. Enter this formula in A2 of Sheet2

=IF(Sheet1!$H2="Yes",Sheet1!A2,"")

This can be copied across into B2:H2. Highlight the cells A2 to H2 and
copy them down into rows 3 to 50. You should now see entries only in
those cells where H on that row contains "Yes".

If you want the rows bunched up, so that empty rows are not visible,
then highlight column H and click Data | Filter | Autofilter (check) -
from the filter pull-down in H1, select "Yes", and only those rows will
now be visible.

Hope this helps.

Pete

Marie wrote:
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