Previous Topic Next Topic

Moving data

Closed
novice - Jun 7, 2016 at 02:58 PM
 novice - Jun 7, 2016 at 04:27 PM
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 responses

Answer 1 / 2
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.
0
novice
Jun 7, 2016 at 04:27 PM
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
0
Answer 2 / 2
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!
0

Similar discussions

AMD data change update new data to DMI
Luis -
dwebb -

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

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

2 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses