Previous Topic Next Topic

Moving data

Closed
novice - 7 Jun 2016 à 14:58
 novice - 7 Jun 2016 à 16:27
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 :)

Related:

2 responses

Réponse 1 / 2
mafresh Posts 1 Registration date Tuesday 7 June 2016 Status Member Last seen 7 June 2016
7 Jun 2016 à 16:09
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.
novice
7 Jun 2016 à 16:27
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
Réponse 2 / 2
Blocked Profile
7 Jun 2016 à 16:24
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!

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses