copy data from 1 worksheet to another based on a condition

Hi I need this information urgently...
Sheet 1 has some data. I put a "IF" condition which when satisfied
needs to input data into Sheet 2. But the problem is that if the
condition is not satisfied it is copying with blanks..

what do you want to do..??

Originally Posted by [email protected]

Hi I need this information urgently...
Sheet 1 has some data. I put a "IF" condition which when satisfied
needs to input data into Sheet 2. But the problem is that if the
condition is not satisfied it is copying with blanks..

I'm thinking you may need to do this with VBA. You may want to ask your
question in the PROGRAMMING group.

"[email protected]" wrote:

> Hi I need this information urgently...
> Sheet 1 has some data. I put a "IF" condition which when satisfied
> needs to input data into Sheet 2. But the problem is that if the
> condition is not satisfied it is copying with blanks..
>
>

Could do with a bit more detail, but your IF statement should be of
this form:

=IF(your_condition, action_if_true, action_if_false)

the "action_if_false" may be set to "" (i.e. return blanks), so you
will need to amend this part if you do not want blanks when the
condition is not met.

Hope this helps.

Pete

[email protected] wrote:
> Hi I need this information urgently...
> Sheet 1 has some data. I put a "IF" condition which when satisfied
> needs to input data into Sheet 2. But the problem is that if the
> condition is not satisfied it is copying with blanks..