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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Purchase Date[/TD]
[TD]Item Name[/TD]
[TD]Date Sold[/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD]2-Dec-2017[/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example of Summary table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item Name[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]ItemA[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]ItemB[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Purchase Date[/TD]
[TD]Item Name[/TD]
[TD]Date Sold[/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD]2-Dec-2017[/TD]
[/TR]
[TR]
[TD]11-Nov-2017[/TD]
[TD]ItemA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25-Nov-2017[/TD]
[TD]ItemB[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example of Summary table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item Name[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]ItemA[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]ItemB[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
I have no idea where to even start to create a summary table like this. Help please!
TIA!