To execute macro whenever there's input in one of the column

[Kehjz]

Hi,

Attached is the example of what I want to achieve, basically I want the macro to copy and paste the content as value in Col.B whenever there's input in Col.A, but to only run the macro when Col.B is empty.

Thanks a lot in advance.

Example.xlsm

[natefarm]

You said columns A and B above, but in your attachment it says columns N and O, so I went with that. Just add this to whatever code is there.

Please Login or Register  to view this content.

[Kehjz]

You said columns A and B above, but in your attachment it says columns N and O, so I went with that. Just add this to whatever code is there.

Please Login or Register  to view this content.

Example v2.xlsm

Hi, a slight modification to the answer you gave me, I will need a few more conditions in it.

Thanks a lot!

[natefarm]

I see that you added some formulas, which work automatically (unless you have Calculation set to manual), so I don't know what you want from me. If you have a question or need something else, let me know.