title: Import .csv to .xls workbook (not just one sheet) using VB macro
body: <p>I am new to VBA &amp; macros in Excel and thus have a question.</p>
  
  <p>I have an Excel workbook, with one main sheet called "BASE". Here there is one column where values are filled. There are two types of these values: </p>
  
  <ol>
  <li><p>Scalar value and can be entered directly in this sheet only. </p></li>
  <li><p>Array of values. So, there is a hyperlink to other sheet in the workbook where such an array of values are to be filled. 
  I have a .csv file containing these values and I have to fill values in .xls file using a VBA macro. Can anyone tell how to do that?</p></li>
  </ol>
  
  <p>Consider the main.xls as having 4 inputs with 2 as scalar and 2 as array (and thus, linking to the other sheets of the workbook). So, when .csv file is read, single values are inserted on the BASE sheet and two tables are filled (for the array input from .csv file) using the hyperlink on BASE sheet for these sheets, in the same Workbook.</p>