Greetings!
I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely.
Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each one with a drop-down enabling the product that is created or sold to be selected.
The next cell to the right is the quantity, reflecting either the number created or sold for that day.
Along the X axis is the date (two cells wide).
I'm trying to create a rolling inventory that finds all the instances of a given product name, and sums all of the instances immediately to the cell's right. It will then subtract all the instances likewise found and summed from the "sold" array. It needs to do this for the entire sheet length, so that dates can be added onto the sheet indefinitely. The relevant table is on the second page of the sheet.
You can view screenshots of page one and two here:
https://ibb.co/f75qvH
https://ibb.co/n5dX9c
I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely.
Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each one with a drop-down enabling the product that is created or sold to be selected.
The next cell to the right is the quantity, reflecting either the number created or sold for that day.
Along the X axis is the date (two cells wide).
I'm trying to create a rolling inventory that finds all the instances of a given product name, and sums all of the instances immediately to the cell's right. It will then subtract all the instances likewise found and summed from the "sold" array. It needs to do this for the entire sheet length, so that dates can be added onto the sheet indefinitely. The relevant table is on the second page of the sheet.
You can view screenshots of page one and two here:
https://ibb.co/f75qvH
https://ibb.co/n5dX9c
Last edited by a moderator:
