title: Macro input Value and extract rows accordingly
body: <p>This is an excel sheet with 4000 rows * 200 columns. </p>
  
  <p>one column has 10 different names in the column.</p>
  
  <p>Function of my macro is to first ask for the name of person whose report is required. Suppose I say "Ram" it will extract all the rows equal to that name and save the values in new workbook and save the file name as "Ram"</p>