title: Command button in Excel to make a copy of a row of data and move that row to a different tab in the same workbook
body: <p>I am trying to get a command button that is placed on a worksheet in Excel that will transfer a line of data to a different sheet based on a certain field in a field. For example I have all the data in a row that has 6 different fields and one is names Type. Then I have worksheets that have the same names as all the Type options. What I want to happen is the user press and update button and the Type for each row is located and then the row is placed in the worksheet that corresponds with that Type. I dont know if this is even possible.</p>
  
  <p>Thanks in advance!
  Bri</p>