Does Excel have IF THEN and automatically copy paste functions?

[cssung711]

Hi everyone

I have a set of data that looks like:

From	To	Cost
0	1	10
0	3	11
0	4	15
1	2	6
1	5	1
2	1	3
2	4	1
3	...	...
...	...	...
4	...	...
4	..	...

<tbody>
</tbody>

And it goes on.


​

Question: is there a way that excel can do --->
IF B2 =1
THEN copy A5, B5, C5 and paste on D2, E2, F2 (or paste on different tab/separate table)
AND copy A6, B6, C6 and past on D3, E3, F3.


IF B2 = 3
THEN stop


IF B3 = 3
THEN copy A9 ..... (similar to when equal 1)


Thanks in advance if anyone have a way to solve this!!

 

[iliace]

Not sure if you are new to Excel, but it has a macro / programming language VBA built-in. You can write your own code, which is similar to your pseudo-code above:

Public Sub ifthenlogic
  If [B2]= 1 Then
    [A5:C5].Copy Destination:=[D2]
  End If

  ' etc...
End Sub

The language is actually Visual Basic, so if you know some programming you can do it pretty easily. Anyway - look into that possibility.

 

[cssung711]

Thank you illianc!!
I guess I'm super new to excel. This is very helpful thanks!