Separate two yellow cell with a white cell between them

  • 1. Active x button positions change by deleting row. Advice me to fixed the buttons


    2. I need a vba please help||, i dont want to remove duplicate all i want is to separate 2 same color cell(entire row) by any other row from above or below use as a seperator. Example between two coke rows i need any white row.

  • Here is one way :


  • first of all i really like to thank you,


    Sir by this i can only insert a blank row, but what i need is to fill the inserted row by any white (data) row "cut/paste".


    Sorry for my english its not my native language.

    Very thankfull to you