ASAP HELP..if formula is false how do i get it to go to next line
 

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.

ASAP HELP..if formula is false how do i get it to go to next line
 

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.

ASAP HELP..if formula is false how do i get it to go to next l
 

isn't there a formula for this?.....hundreds of people use this workbook and
we are trying to prevent human error.....so we don't want anyone to copy and
paste. we just want our formula to continue its search through the rest of
work sheet one and not end .

"Shane Devenshire" wrote:

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.

ASAP HELP..if formula is false how do i get it to go to next l
 

No. There isn't "a formula for this". If statements look at exactly the
cells you identify. They don't "continue on".

That's why Excel has lots more features which deserve your attention.
Filtering is one of the best.

If you're serious about going to the effort of preventing human error, you
will need a macro.

Regards,
Fred.

"xania" wrote in message
...
isn't there a formula for this?.....hundreds of people use this workbook
and
we are trying to prevent human error.....so we don't want anyone to copy
and
paste. we just want our formula to continue its search through the rest of
work sheet one and not end .

"Shane Devenshire" wrote:

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.

ASAP HELP..if formula is false how do i get it to go to next l
 

What about some +1 function or something? does that go to the next line and
start my formula all over.

"Fred Smith" wrote:

No. There isn't "a formula for this". If statements look at exactly the
cells you identify. They don't "continue on".

That's why Excel has lots more features which deserve your attention.
Filtering is one of the best.

If you're serious about going to the effort of preventing human error, you
will need a macro.

Regards,
Fred.

"xania" wrote in message
...
isn't there a formula for this?.....hundreds of people use this workbook
and
we are trying to prevent human error.....so we don't want anyone to copy
and
paste. we just want our formula to continue its search through the rest of
work sheet one and not end .

"Shane Devenshire" wrote:

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.

ASAP HELP..if formula is false how do i get it to go to next l
 

Sorry, the answer is still no.

Regards,
Fred,

"xania" wrote in message
...
What about some +1 function or something? does that go to the next line
and
start my formula all over.

"Fred Smith" wrote:

No. There isn't "a formula for this". If statements look at exactly the
cells you identify. They don't "continue on".

That's why Excel has lots more features which deserve your attention.
Filtering is one of the best.

If you're serious about going to the effort of preventing human error,
you
will need a macro.

Regards,
Fred.

"xania" wrote in message
...
isn't there a formula for this?.....hundreds of people use this
workbook
and
we are trying to prevent human error.....so we don't want anyone to
copy
and
paste. we just want our formula to continue its search through the rest
of
work sheet one and not end .

"Shane Devenshire" wrote:

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.

ASAP HELP..if formula is false how do i get it to go to next l
 

=if(or('22'!b21,="drf6",'22'!c8="marc"),'22'!b8 )
we want it to look at the next line

And what would the next line be?
=if(or('22'!b22,="drf6",'22'!c9="marc"),'22'!b9)

???

--
Biff
Microsoft Excel MVP


"xania" wrote in message
...
What about some +1 function or something? does that go to the next line
and
start my formula all over.

"Fred Smith" wrote:

No. There isn't "a formula for this". If statements look at exactly the
cells you identify. They don't "continue on".

That's why Excel has lots more features which deserve your attention.
Filtering is one of the best.

If you're serious about going to the effort of preventing human error,
you
will need a macro.

Regards,
Fred.

"xania" wrote in message
...
isn't there a formula for this?.....hundreds of people use this
workbook
and
we are trying to prevent human error.....so we don't want anyone to
copy
and
paste. we just want our formula to continue its search through the rest
of
work sheet one and not end .

"Shane Devenshire" wrote:

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.