amyylouise
New Member
- Joined
- Sep 3, 2013
- Messages
- 22
I have a table 'InventoryTracking' which contains all my data for inventory coming in and out.
I would like to create a summary sheet showing what items I currently have in stock.
If the "Date Sold" column is blank, the item is still in stock.
Example of my InventoryTracking table:
<tbody>
</tbody>
Example of Summary table:
<tbody>
</tbody>
I have no idea where to even start to create a summary table like this. Help please!
TIA!
I would like to create a summary sheet showing what items I currently have in stock.
If the "Date Sold" column is blank, the item is still in stock.
Example of my InventoryTracking table:
Purchase Date | Item Name | Date Sold |
11-Nov-2017 | ItemA | |
11-Nov-2017 | ItemA | 2-Dec-2017 |
11-Nov-2017 | ItemA | |
25-Nov-2017 | ItemB | |
25-Nov-2017 | ItemB | |
25-Nov-2017 | ItemB |
<tbody>
</tbody>
Example of Summary table:
Item Name | Qty |
ItemA | 2 |
ItemB | 3 |
<tbody>
</tbody>
I have no idea where to even start to create a summary table like this. Help please!
TIA!