Hello All,
I have an estimating sheet (portion attached) that I have been working on and I have hit a block. I have a worksheet change event that clears the data in cells B25:29,B32:33, and L3:21 when the option 'Standard' is selected in cell B3 from a drop down list. I used the following code to make this happen:
As you can see, there are three other "phases" that are just like phase 1 (directly below), where the macro runs. I want it to do the same thing in each of the other three phases, but can't seem to get it. I run into only being able to run one worksheet change event and can't figure out how to nest them. Any help would be appreciated.
Bookmarks