A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

formula for copy and paste



 
 
Thread Tools Display Modes
  #1  
Old December 27th, 2005, 10:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 27th, 2005, 10:55 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 27th, 2005, 10:59 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 03: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 01:52 AM
Copy and Paste Conditional Sum Formula David Kinkella Worksheet Functions 1 September 20th, 2003 01:18 AM


All times are GMT +1. The time now is 08:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.