VBA Copy rows to another sheet due to cell value from dropdown list

  • Hi there,

    I have some issue with my Excel list. What I want to achive?


    In specific column (lets say B) in sheet1 I have dropdown list with 8 predefined text values (X1, X2, X3, ... , X8). I want to pull few cells (for example Cx, Dx, Fx, where x is variable of row) from every row with value X1 or X3 in B column to sheet 2. It wouldn't be a problem if i could use casual =If function in cell, but I want those, to be one after another, without blank rows between. All google answers which I found had some errors and I have 0 exp with VBA.


    If my problem needs to be described in more detail, please let me know.

  • It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific

    cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). Click the "Attachments" link to post your file.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!