Please refer the table below.
A B
-------------------
1 test 1
2 bb 0
3 test 1
4 dd 0
5 test 1
-------------------
I need to write a macro which will copy values from Col B to Col A,if the value of the Col A is "test".

Please let me know if you have any suggestion.

Thanks,

Abhik