how to do subs track (-) in between 2 piovat table ,

Hi
I am very much thank full to you all, for your help.
So I am agaih come up with one more quire, I am having a work **** which contain roll in & roll out sheet ,as well as roll in piovat table & roll out piovat table in saprate sheet , now I want to subs track roll out from roll in and resul in piovat table on other sheet (result piovat), pls see the attached file , need your help ………
need piovat.xlsx

ya, pls ee the attched file with result i expectiong in "result piovat ",

hello ,
i had made sheet1 only for example(to show you the result piovat details ), actult there will be only 5 sheet s 1 rool in 2 roll in piovat 3 roll out 4 roll out piovat 5 result piovat
i want that sheet result piovat will take data from roll in piovat & roll out piovat ( roll in piovat -(minus) roll out piovat )
waiting for your reply

yes, say for exmple ,in "roll in" there is 3 roll of 5 inch, 200 mt , 9mm and in "roll out" there is 1 roll of 5 inch, 200 mt , 9mm now i want that in "result piovat" sheet to show 2 roll of 5 inch, 200 mt , 9mm as a balance

hai, thanks DILIPANDEY . thannks for your reply and solution.
but in this you had made a sheet "balance"which call data from rollin as piovat table and then less it from roll out shee by formula., but i want to do it with pioat table , that mins piovat table of roll in - (minus) piovat table of roll out = piovat table of balance roll .

and what if the type of roll will increase in roll out sheet ,then its not taking that new aided roll type from roll out abecause of the formula [=E3-IFERROR(INDEX('roll out '!$E$1:$E$5,MATCH($B3&$C3&$D3,'roll out '!$B$1:$B$5&'roll out '!$C$1:$C$5&'roll out '!$D$1:$D$5,0)),0) ].... that is $E$1;$E$5

so pls suggest what to do instead of this .

thanks for ur reply ,ya we can do that , but that we have to do every time or when ever the roll out category increase, but how to do it automatic .

hi, thanks for your support , its very use full to me.
as per your last (attached file from you ),if i remove the date from piovat then ur formula do not work at all

hi, thanks for your support , its very use full to me.
as per your last (attached file from you ),if i remove the date from piovat then ur formula do not work at all

hi pls ee the attached file , i want apply your sujested formula in this .

thanks. first of all , i don't want any date . its only use for input of roll , but after input it will goes to stock, and from there it will use as per our need of roll. so its doesn't mater at which date it was enter .

ya, now its working, but still some problem is there , pls seethe attached file ,foe example there is total 8 roll of 5 inch, roll in sheet & piovat table , and when i put 5 roll out of 5 inch in roll out sheet , its shows -2 as a resul and the other 5 inch roll remain same . i want it to make a toatl of 5 inch roll as the roll size, mm and meter are same , so it shase to show total of 8 roll and then minus the out roll from it so the result will be remain 3 roll

thanks a lot, its working as per my requrment , thnaks ..............

I want to B look like A , that mins in B , automatic piovat tale show on ly one time a 8 because there is 2 type in 8 inch roll, but iwant it sholud show 8 for both the type

hi, its not working

hi, its not working