Results 1 to 13 of 13

VBA Script to add and remove rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    18

    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
    Attached Files Attached Files
    Last edited by Skorpionkz; 03-20-2013 at 11:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1