VBA Script to add and remove rows

Hi guys,

I updated information for script I need:

I have 2 Sheets: Conditions, DDL

Script 1 Should check if in Condition Sheet cell value B15 is Yes or No.

If "No" Script Should check if range A27:A50 contains (not equal) CALBridge or CALBrdg and if yes delete each row which has it.

If "Yes" do nothing.

Script 2.
1. In Sheet DDL, Script should check how many cells have value "Ok" in range "I8:I31"
2. In Sheet Conditions, Script should insert variable number of rows depending on how many "Ok" it found in point 1
3. Sheet DDL, in range A8:I31 for all "Ok" in column "I" copy appropriate Cells A:B and paste to Conditions Sheet in inserted raws
4. There is drop down menu in Sheet DDL, it takes value from Sheet DDL range A4:B4, when I copy this to another sheet drop down menu does not follow same conditon, so script should update dropdown menu to collect information from Sheet DDL range A4:B4 and by default select No from this menu

Both scripts I will associate with buttons.

I hope this make more sense than initial script I asked for.

Thank you