title: Create, name, and populate new workbook with data
body: <p>I have an Excel sheet with two columns of data. Column A has the desired new workbook names and Column B's adjacent cell has the data I want in the new work book.</p>
  
  <p>So if <code>032411</code> is in column A and <code>50</code> is in column B then the macro would create a new workbook named <code>032411</code> and <code>50</code> would be in cell <code>A1</code> of that workbook.  </p>