example: I want to send the text in C7 of sheet one to C7 of sheet three if K7 on sheet one = no. I use 'sheet one'!$C$7  to automatically enter the data from C7 sheet one to C7 sheet three, but what if I only want that data to populate sheet three if sheet one K7 = no. I hope this makes sense.
Thanks,

---

Answer from Richard Rost:

Just wrap what you currently have inside of an IF function. See this tutorial for help:

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx