title: Search for string in all sheets except first sheet and write corresponding sheet names to first sheet of excel file using macros
body: <p>Let us say our first sheet's name is 'A'. How can we write data's sheet names in same column(B1) to sheet A. And again we search for SheetA's C1,D1 so on..</p>
  
  <p>i found this code here this is useful but does not respond my need</p>
  
  <p><a href="https://stackoverflow.com/questions/4734794/search-for-string-in-all-sheets-of-an-excel-file-using-macros/17145535#17145535">Samar's code</a></p>