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.