VBA Script to add and remove rows

[Skorpionkz]

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

[patel45]

attach a sample file with comments

[Skorpionkz]

Correct attachment is in post 1.

I cannot remove this one. Can some admin remove this attachment or this post?

[arlu1201]

Admin note: I have merged your new thread with this thread. If you need to move a thread to the top of the list or to page 1, you have to add a new post to the same thread - this will move your thread up (its called bumping) to the top. Please do not create duplicate threads for the same question.

Since i have replied to this thread, it has already been bumped, so you do not need to do it again.

[Skorpionkz]

Bumping my tread

[arlu1201]

Can you please explain the 2nd part -

Second script should use Value from cells D34:36 in Sheet DDL as Condition for Pivot (cells B34:B36) and copy result (copy all non blank rows 38:62) of Pivot to Condition Sheet starting with raw 25.

Its not clear. There is no data in D34:D36 in sheet DDL.

[Skorpionkz]

I'm sorry when I deleted another information it all moved up
It should be like that now:

Second script should use Value from cells D28:30 in Sheet DDL as Condition for Pivot (cells B28:B30) and copy result (copy all non blank rows 33:56) of Pivot to Condition Sheet starting with raw 25.

I'm sorry for confusion

[Skorpionkz]

Question to skilled guys. Does my request is so complex that no one giving solution?

I have prepared my Spreadsheet with Pivot. Now it is not 100% what I want to have. That why I am asking for this script, but if this is too complex I will stay with what I have.
Please just let me know if there is a point to wait on it?

[patel45]

Question to skilled guys. Does my request is so complex that no one giving solution?

I don't know, I asked for a sample, you attached an empty file...

[Skorpionkz]

Did't realise it is empty. It's working on my computer. Re-uploaded.

[AB33]

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

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

The last data you have is in Range 23, so I do not know where you are getting your data from.

[Skorpionkz]

There is second part of request which adding data. So if we will start macro again this range (A25:A48) might have data

Second script should use Value from cells D34:36 in Sheet DDL as Condition for Pivot (cells B34:B36) and copy result (copy all non blank rows 38:62) of Pivot to Condition Sheet starting with row 25.

little clarification: Macro should actually not copy rows from result of Pivot, this should insert rows to Conditions Sheet

[Skorpionkz]

I updated information about script i need.
Please check out in first post.