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
Prev Previous Post   Next Post Next
  #1  
Old December 27th, 2005, 09: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


 




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


All times are GMT +1. The time now is 07:59 AM.


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