Hi,

Try using Auto Filter or Advanced Filter with your condition, then copy the
results to the second sheet.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"xania" wrote:

We are trying to take only specific information from one worksheet to print
it on another worksheet in the same workbook, if it matches the specified
criteria. We have the following
=if(or('22'!b21,="drf6",'22'!c8="marc"),'22'!b8) which works for the criteria
we want on the sheet, except for when the criteria is not met it puts FALSE
in our cell and we want it to look at the next line and not input FALSE or
leave a blank line but continue on until "drf6" or "marc" is found again. If
the criteria is true that is the only info we want to print on the second
worksheet, no blank lines or false statements.