Hi everyone
I have a set of data that looks like:
<tbody>
</tbody>
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!!
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!!