VBA code to find and select a multiple cells in a range that contains a certain string : I want to look for a string "GAS CYLINDERS" in range "B17:B29" and if a cell contains the given string, goto to column "H"(from "B") of the same row of the cell which contains the string then, select it.I want it to loop till row 29 and keep on selecting the eligible cells and take the sum of the values of all selected cells...
and finally , paste the total in another cell ("M22")
[Image for reference][1]


  [1]: https://i.stack.imgur.com/1IMYV.png