I need your help write a macro

**abhik0203** · 08-09-2007, 08:48 AM

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

**mudraker** · 08-09-2007, 09:05 AM

Welcome to excelforum

Please read forum rules - see links below
Please select suitable thread titles

Try this macro

Please Login or Register  to view this content.

**Ron Coderre** · 08-09-2007, 09:12 AM

Try this

Please Login or Register  to view this content.

Does that help?

**abhik0203** · 08-09-2007, 09:37 AM

Originally Posted by Ron Coderre

Try this

Please Login or Register  to view this content.

Does that help?

I can not execute the code. I am getting an error that.."Macros in this project are disabled". I have changed the security level of the macro to low. I am still getting the error.

Please suggest.

**Ron Coderre** · 08-09-2007, 09:47 AM

Just a guess.......

You changed the Macro Security to LOW after that workbook was already set to disable macros. Try closing it and re-opening it.

NOTE: NEVER set Macro Security to LOW. That setting will run ALL macros without asking your permission. You should set it to MEDIUM. That way Excel will prompt you to allow macros in any workbook containing them.

Does that help?

**abhik0203** · 08-09-2007, 10:06 AM

Originally Posted by Ron Coderre

Just a guess.......

You changed the Macro Security to LOW after that workbook was already set to disable macros. Try closing it and re-opening it.

NOTE: NEVER set Macro Security to LOW. That setting will run ALL macros without asking your permission. You should set it to MEDIUM. That way Excel will prompt you to allow macros in any workbook containing them.

Does that help?

Thank you very much!