title: Excel Macro to read multiple files in a folder and search in it
body: <p>I have some excel workbooks of same header rows. I need to search in a particular column in all these workbooks and do a countif kind of functionality in a corresponding column( different than the first column)
  For eg.. Column  A has names of boxes, B has information about the contents in each box. I would like to search multiple excels in folder and get a report of unique box names and their content counts. Box A has 5 apples, 2 oranges , 1 mango.</p>
  
  <p>I hope this requirement is clear enough. Could anyone help me with a base axcel macro code?</p>