title: EXCEL Save data into different workbook - VBA
body: <p>Good day,</p>
  
  <p>I have a sheet that requests a user to enter data and then click a button to save the data into the database. The database is currently located in the same workbook "Different worksheet".</p>
  
  <p>What i basically need is for this data to be saved on a different worksheet that i call "Consolidated.xlsx" which is available in a different folder "C:/reports/consolidates.xlsx" so that only I can access this data and no one else</p>
  
  <p>Please let me know if you can help</p>
  
  <p>Document currently available under the following link:
  www.dropbox.com/s/3wea245lmek8hef/FormSheet.xls</p>
  
  <p>Thanks</p>