Moving data

novice - Jun 7, 2016 at 02:58 PM
 novice - Jun 7, 2016 at 04:27 PM

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 responses

mafresh Posts 1 Registration date Tuesday June 7, 2016 Status Member Last seen June 7, 2016
Jun 7, 2016 at 04:09 PM
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
Blocked Profile
Jun 7, 2016 at 04:24 PM
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!