title: Import dynamic range from one Excel workbook to another Excel workbook
body: <p>I am new to VBA and I would need help with the following:</p>
  
  <p>I have 3 Excel workbooks (wb1, wb2 and wb3). wb1 and wb2 both contain column A (dates) and column B (numbers). On a monthly basis, new data is added to both columns. wb1 and wb2 are stored in the same folder.</p>
  
  <p>In wb3 I perform calculations based on the data of either wb1 or wb2. Therefore I need to select the respective workbook (wb1 or wb2) on a drop down list in wb3. The dynamic data range of my selection should then be copied into wb3.</p>