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.
Bookmarks