Copy / Paste Formula

[Guest]

Is there a formula that will allow me to paste the contents of a cell to
another location based on the value of another cell, excpet when the value is
0??

I am using the spreadsheet for an estimating program, and then turning the
estimate into a contract. So I need the items that are selected in the
estimate (eg. 1 dumpster, 20 trees) to be sent to the contract, but not the
empty rows.

Thank you for your help.

 

[Guest]

Use an If function

if(a1 <> "",a1)
if the contents in cell as is not blank then display it contents
this is not a paste but a reference.

You can later copy the new cell(s) and use paste special to insert the value
instead of the formula