Run diffrent macro if cel have values Yes on NO

  • Hi,

    I have a query and one macro that run on Sheet1 to copy values to Sheet2.

    I'm trying to create a macro in Sheet2 that will run if the value of the cell is YES or NO

    I have created 4 macros for Sheet 2 and named them Macro1, Macro2 ,Macro3, Macro4

    If cell A7 has value YES and a8 , A9 A10 have value NO, then Macro1 should run.

    If cell A7 and A8 have value YES and A9 and A10 has value NO, then Macro2 should run

    If cell A7, A8 and A9 have value YES and A10 has value NO, then Macro3 should run.

    If cell A7, A8 , A9 and A10 have value YES then Macro4 should run.

    Thank you!

  • Try this

    This is worksheet event code, read this if you aren't sure where to paste it.

    Where to put the code

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!