Thanks. I couldn't see the tree for the forest, your formula worked, all I
had to do was add in the worksheet name as well the cell.

"JE McGimpsey" wrote:

Functions can only return values, they can't directly affect (i.e.,
paste to) other cells.

So in worksheet 2, cell A2, enter

=IF(x = 0, 'Worksheet 1'!A2, "")

where x is your "cell" reference. Copy that across to worksheet 2, cell
C2.



In article ,
Margo wrote:

What I want to do: create a cell function that will - if cell = quantity 0
then copy worksheet 1 cells a2 to c2 and paste that information to worksheet
2 cells a2 to c2