title: Copy a row of data from one sheet to another automatically in Excel
body: <p>Edit
  Hello, 
  Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 
  ie When i type Line 1 etc i want excel to automatically take the row of data for Line 1 on my data sheet and insert it into the target row, cannot use VBA 
  Appreciate help, i am a beginner</p>