Does Excel have IF THEN and automatically copy paste functions?

[cssung711]

Hi everyone

I have a set of data that looks like:
[TABLE="width: 100"]
<tbody>[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]1[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]3[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]4[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]..[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]

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!