Copy value of cell d22 to e22 based on value in cell d22

Hi All,

I need the value of Cell $E22 to equal the value of Cell $D22 if certain criteria are met ...

How can I convert this formula into a VBA macro?

=IF(OR($D22="Long Term Sick",$D22="Maternity Leave",$D22="Left the Business"),$D22,"")

I would like this macro to work on rows $D22:$D221


Any help or suggestions would be appreciated

Try, not in module, in Worksheet_Change Event

Please Login or Register  to view this content.

Kind regards
Leo

Another option

Please Login or Register  to view this content.

Thanks Leo,

Tried your suggestion but it didn't seem to work ....

Maybe I did something wrong?

Think you put code @ wrong place

try in this exemple


Kind regards
Leo

Hi Fluff13,

Had more success with your suggestion.

I changed the value of the Target .Offset from 1 to 84 as I need to copy a value from the array to Cell CJ22 not E22 and that works fine.

Your help is appreciated.

Many thanks ....

Thanks for your help Leo but I think I now a have a solution that is working ....
I will mark this thread as closed ...

Glad we could help & thanks for the feedback

How about

Please Login or Register  to view this content.