title: Export data from one sheet to another via drop down list - VBA Excel Macro
body: <p>I have an Excel workbook with two worksheets on.
  Sheet 1 is a form which gets filled in and it has a submit button (created with VBA) which takes the data and adds it to the next empty line on sheet 2.
  So sheet 2 is filled with previously submitted form information and sheet 1 can be cleared (again via a button created with VBA) ready for the next lot of information. </p>
  
  <p>Each entry has a unique number for reference purposes, but what I would like to do is on sheet 1(the form) to have a drop down list of all the unique numbers which I can select one and for it to bring all the relevant information back in to the form so any edits can be made and a button to be able to save/overwrite the data instead of saving it as a new line.</p>
  
  <p>So would like to be able to bring the data back to sheet 1 to edit/amend/save/overwrite.</p>
  
  <p>My VBA knowledge is limited as this is the first project I have dealt with it on so I'm still learning the basics as I go.</p>
  
  <p>Any advice or suggestions would be gratefully appreciated.</p>
  
  <p>Many Thanks</p>
  
  <p>Rachael. </p>