Copying rows based on criteria

[sbeek]

We are creating a workbook to track out daily inventory going in and out in Excel 2016.

Worksheet 1 contains 3 tables:
- 'Inventory built' (IN)
- 'Inventory sold' (OUT)
- balance of each item

Worksheet 2 contains another customer's inventory that we are also holding on site and also contains 3 Tables:
- Inventory we have built for them (IN)
- Inventory we have shipped for them (OUT)
- Their balance

Worksheet 3 contains 3 tables:
- Balance from Worksheet 1
- Balance from Worksheet 2
- Total of those 2 tables.

We are wanting to auto populate all the rows on the 'IN' table on Worksheet 2 from our Worksheet 1 Inventory Sold table, if the customer cell contains that particular company name. However, I do not want any spaces between the rows.

Any ideas on how to do this. Anything that I've found so far on google hasn't worked for me.

Thanks!