Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy and paste the text of a formula? | Excel Worksheet Functions | |||
Paste Formula | Excel Discussion (Misc queries) | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions |