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