Robert,
Your function would be in the sheet you are "sending" the data too. In
Sheet2!A1 you can enter the formula,
=if(Sheet1!$A$1="Yes",Sheet1!A2,"")
This leaves the cells in Sheet 2 blank if there is not a "Yes" in
Sheet1!A1.
You can then drag this formula down to A3 in Sheet2. The dollar signs
keep the reference to cell A1 in Sheet 1 absolute so it will not change
when you drag it, however, the references to A2 in Sheet 1 will change
to A3,A4 as needed in your example.
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=496277