formula for copy and paste

[Guest]

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

 

[SteveG]

Robert,

Your function would be in the sheet you are "sending" the data too. I
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" i
Sheet1!A1.

You can then drag this formula down to A3 in Sheet2. The dollar sign
keep the reference to cell A1 in Sheet 1 absolute so it will not chang
when you drag it, however, the references to A2 in Sheet 1 will chang
to A3,A4 as needed in your example.

Cheers,

Stev

 

[Guest]

Functions 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="yes",sheet1!a2,""), and copy that into
a2, a3, a4.