formula for copy and paste
 

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

formula for copy and paste
 

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

formula for copy and paste
 

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