software

can i create a condtional function in a cell that would send data in one row
of cells to a cell in another worksheet.
ex
a1
a2= aaaa
a3= bbbb
a4=cccc
a5=if a1 is yes,send a2,a3,a4 to Sheet2!a1,a2,a3

thanks,

robert

Robert,

Your function would be in the sheet you are quot;sendingquot; the data too. In
Sheet2!A1 you can enter the formula,

=if(Sheet1!$A$1=quot;Yesquot;,Sheet1!A2,quot;quot;)

This leaves the cells in Sheet 2 blank if there is not a quot;Yesquot; 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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=496277Functions can't 'send to'; they only 'pull from'. That is, a function in a
cell results in values IN THAT CELL. If you want to make the appearance of
sheet1!a2:a4 in sheet2, put the formulas in sheet2 that conditionally pull
from sheet1.
Ex: in sheet2!a2, =if(sheet1!$a$1=quot;yesquot;,sheet1!a2,quot;quot;), and copy that into
a2, a3, a4.

quot;robbie5quot; wrote:

gt; can i create a condtional function in a cell that would send data in one row
gt; of cells to a cell in another worksheet.
gt; ex
gt; a1
gt; a2= aaaa
gt; a3= bbbb
gt; a4=cccc
gt; a5=if a1 is yes,send a2,a3,a4 to Sheet2!a1,a2,a3
gt;
gt; thanks,
gt;
gt; robert
gt;
gt;