If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
why cant I copy and paste a formula? | Bryan J Bloom | General Discussion | 2 | November 25th, 2005 02:47 PM |
adding row to forumla | carrera | General Discussion | 9 | August 23rd, 2005 10:24 PM |
Copy Paste of Formula Produces Incorrect Result | JLa | General Discussion | 1 | May 17th, 2005 06:56 PM |
Problem copying formula to range of cells | Ellen | Setting up and Configuration | 4 | November 20th, 2004 12:52 AM |
Copy and Paste Conditional Sum Formula | David Kinkella | Worksheet Functions | 1 | September 20th, 2003 01:18 AM |