formula for copy and paste

[robbie5]

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. 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

[bpeltzer]

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.

"robbie5" wrote:

> 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
>
>