Hello everyone.
Appreciate any help I can get.
Currently I am using Excel 365
I am currently running product inventory management system.
I need to be able to know how much product is left from each store to decide how much more to order from those.
I have multiple sheets containing multiple products. (Sheet 1 containing apples, sheet 2 containing pears)
Within the sheet for apples:
Is there anyway to "seperate" store A and B as their own individual blocks with their own formulas.
I need to use the same sheet within excel instead of seperating them into different sheets since they have the same products
Is there any way to calculate the balance for each store without manually calculating them.
I also do welcome any ideas on ways to optimise this.
Is there any way to create a database
So that I can create a data entry sheet containing
Store Name: A
Product: Apples
Input In: 30
Input Out: 30
And then it automatically inputs in for me?
Appreciate any help I can get.
Currently I am using Excel 365
I am currently running product inventory management system.
I need to be able to know how much product is left from each store to decide how much more to order from those.
I have multiple sheets containing multiple products. (Sheet 1 containing apples, sheet 2 containing pears)
Within the sheet for apples:
Is there anyway to "seperate" store A and B as their own individual blocks with their own formulas.
I need to use the same sheet within excel instead of seperating them into different sheets since they have the same products
Is there any way to calculate the balance for each store without manually calculating them.
I also do welcome any ideas on ways to optimise this.
Is there any way to create a database
So that I can create a data entry sheet containing
Store Name: A
Product: Apples
Input In: 30
Input Out: 30
And then it automatically inputs in for me?