Thanks, that answer set me on the right path. I just had to create an IF
formula in each cell on sheet 2 that returned the content of the cell on
sheet 1.
"Max" wrote:

One guess ..

Assume quantity is listed in D2 in Sheet1

In Sheet2,
Put in A2:
=IF(Sheet1!$D2="","",IF(Sheet1!$D2=0,Sheet1!A2,"") )
Copy A2 to C2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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