Moving data [Closed]

Report
-
 novice -
Hello,

this is driving me mad and im sure its simple.
i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it to copy and paste the data from columns A&B in that row, to columns C&D on sheet 2.
any ideas what formula i need??
thanks :)

2 replies

Posts
1
Registration date
Tuesday June 7, 2016
Status
Member
Last seen
June 7, 2016

Try this, click on the information to be copied, if you want to copy A&B, click A, hold control and click B, the two will be highlighted, then right click on your mouse, select COPY, then click sheet 2, now click once on C, right click and select the first pasting option, it is done.
That doesn't work. I don't just need to copy and paste. I need it to automatically copy data from 2 cells if another cell hasn't a certain value. I think it needs a combination of IF and vlookup but I'm giving up because it is making my head hurt

OK, here is the if statement syntax for Sheet2!C2:
=IF(Sheet1!F2="Yes",Sheet1!A2 & " " & Sheet1!B2)

Use this as an example, and apply that to your own worksheet!


Post back, if you have any questions!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!