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 "Like" 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!

Register Yourself Login