Ideas on how to create a database to export the data

[Zumbibahu]

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?

 

[Dan_W]

The balance at any given time is calculated (manually and otherwise) as:
BALANCE = INPUT IN - (CUMULATIVE) INPUT OUT
I suspect your next question will be - 'how does one get this 'cumulative' input out figure?' If you're relying on formulas in the workseet, you could make a sepaparate 'helper column' that subtotals with each 'input out', and then just deduct that from the Input In.

 

[Zumbibahu]

The balance at any given time is calculated (manually and otherwise) as:
BALANCE = INPUT IN - (CUMULATIVE) INPUT OUT
I suspect your next question will be - 'how does one get this 'cumulative' input out figure?' If you're relying on formulas in the workseet, you could make a sepaparate 'helper column' that subtotals with each 'input out', and then just deduct that from the Input In.

Thanks for your reply, but I dont get you. Could you explain more?

Thank you

 

[Dan_W]

I'm not entirely sure that I can. Are you familiar with formulas in Excel (namely, the SUM formula)?