I want to set up a function that will allow the contents in a cell from
another worksheet be copied over to a new worksheet if the criteria is TRUE.
In other words, instead of having to use "TRUE" or "FALSE" as the answer to a
function, I want the answer to be pulled from a cell in another worksheet?

Is there anyway to do this?

Thanks,
Lisa

=If(A1B1,Sheet1!A1,Sheet2!B1)
Something like that?

Charles

LisaLisaKK wrote:
I want to set up a function that will allow the contents in a cell from
another worksheet be copied over to a new worksheet if the criteria is TRUE.
In other words, instead of having to use "TRUE" or "FALSE" as the answer to a
function, I want the answer to be pulled from a cell in another worksheet?

Is there anyway to do this?

Thanks,
Lisa