title: How to automatically fill data in an invoice in Google Sheets
body: <p>I am sharing <a href="https://docs.google.com/a/al-ezzi.com/spreadsheets/d/1nMUSuRGUVaNpZV1g9ji7LmqQLZ5AcX0TnDf01LQgM40/edit?usp=sharing" rel="nofollow noreferrer">this</a> sheet with you so that you can have a look and give me a proper solution. Basically what I want to do it generate an invoice based on the data entered in "Purchases" but I don't know how to do it as the lot numbers aren't always in the proper sequence. Therefore, if you notice in the "Sale &amp; Inventory" sheet, I have to create multiple entries for one invoice. Is there a simpler method where the invoices are generated automatically? I don't want more than 30 lots/invoice.</p>
  
  <p>Thanks,</p>
  
  <p>Huzaifa.</p>