title: Copy row from one sheet to another based on new entry in list
body: <p>I am building a workbook for another user and want it as automatic as possible. In sheet 1 user will copy in sales data, containing multiple rows for each product number. The amount of rows will be different each time.
  I want to copy one row of each to Sheet 2 where there is a Vlookup to a Pivot.</p>
  
  <p>Clarifying:</p>
  
  <p>Columns A:K have product data. But there are multiple rows of sales data for each product, delivery to different customers. I just want to copy one row each produkt to another sheet.</p>
  
  <p>I can't find the VBA for " for each new number in column F:F do... "</p>
  
  <p><a href="https://i.stack.imgur.com/rnxXi.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rnxXi.jpg" alt="enter image description here"></a></p>