hi,
I want to perform a set of actions(macro), when a particular value is entered in a cell. For e.g., I have a macro named "m1'. When the user enters 1 in cell A1, I want to run the macro"m1". Again, if the user enters 2 in cell A2, again I want to run the same macro. Similarly, I want to keep running the macro "m1" as long as the user enters a serial number in column A in consecutive rows. How do I go about it. Please help.
I want to perform a set of actions(macro), when a particular value is entered in a cell. For e.g., I have a macro named "m1'. When the user enters 1 in cell A1, I want to run the macro"m1". Again, if the user enters 2 in cell A2, again I want to run the same macro. Similarly, I want to keep running the macro "m1" as long as the user enters a serial number in column A in consecutive rows. How do I go about it. Please help.