Hello all,
I need to search col F and if any cell contains the words "sell" or "buy" then concatenate that row starting in col H up to the cell which says " Q.Ta' " .
Put the result in col E of the corresponding row.
The result of the macro should give:
E2 will be: Elect/56 3%
E4 will be: Mary-12 FHY 67
E7 will be: IBM 55 tr NYC
… and so on.
Please see attached WB1.XLS
Appreciate your help.