I am looking for a VBA code that serches text "Descriptive Title that explains your problem" in clolumn A and Merges all Cells data in same row from column B to last. The output data will be in column B in same row. VBA must not work in Sheettext1 and Sheettext2.