Suppressing Blank Rows When Populating One Worksheet With Data from Another

[nycstinger]

Column M of Sheet 1 contains either "y" or "n". I'd like Sheet 2 to populate with data in cells A-D but only for rows where column H = "y".

I can figure out the condition easily enough:
=IF('Sheet 1'!M2="Y",'Sheet1'!A2,"")
Repeat for each column to display. But I'd like to suppress the blank rows for both display purposes and the possibility of using in a Word mail merge.

[Palmetto]

Column M of Sheet 1 contains either "y" or "n". I'd like Sheet 2 to populate with data in cells A-D but only for rows where column H = "y".

I can figure out the condition easily enough:
=IF('Sheet 1'!M2="Y",'Sheet1'!A2,"")

If its a case of "y" or "n" then your formula should be:

=if(or(sheet1!M2="Y", sheet1!M2="N"),Sheet1!A2,"")

But I'd like to suppress the blank rows for both display purposes and the possibility of using in a Word mail merge.

By suppress, do you mean you want to hide those rows? You could use AutoFilter to do this. Or, use Advanced Filter with criteria and copy non-blank cells to another sheet.

[nycstinger]

I'm learning more about Excel in the last week than I have in years. Thanks for the help.