I'm not sure where to place my If Then statement

Hello,

I have very little knowledge of VBA and am having a difficult time placing an If Then statement in the correct spot. I need cell I11 to read "1.50" if cell J11 is "General Inspection Level II". I would like it to be within Worksheet_Change. Basically I just need to know where to place

If Range("J11").Value = "General Inspection Level II" Then
Range("I11").Value = "1.50"

If something works better than If Then I am all for it! Thank you in advance!

Please Login or Register  to view this content.

That works for most cases. For some reason when I select "General Inspection Level II" from the dropdown list it updates cells I11 and I7, but it doesn't update the number of rows. If I make any other change the rows update perfectly. It is only when I switch the General Inspection Level II.

By the way, thank you for shortening that code! I feel a little silly about how much time I spent on the original.

Here is a sample workbook.

I7 has the possibility to change. If one of our inspectors is using the report but the number of samples is not based off AQL, then they will just type over the formula.

=C11 needs to be included in cell AW2 because the sample size for order quantities between 2 and 8 for General Inspection Level II is equal to the order quantity and is subject to change depending on the contents of different cells.

The purpose of this report is to automatically determine the sample size based on order quantity, AQL level and customer requirement then automatically hide the rows that will not be used.

As previously stated, everything works perfectly except when changing cell J11 to "General Inspection Level II". It works when changing it to C=0 and QS096, but not the other way around.

I forgot to try your code! Everything works except when changing Cell I7. As explained above, there may be circumstances where someone needs to input a value over the formula in I7, so I'll need it to run the code then, too.