HI. LalitPandey87
thanks for replying

Charles must be right, I'm not explaining right.
I did the tests, but it is not, for example, what I realize is that it thus:

I'll take the example of "Motor EK" on worksheet "Ordem da Matriz", he gave 1500, but the spreadsheet "Repasse a filial" have the "Motor EK" with quantities of 2,500, 2,600, 21,000 and 45,000, what he has to do is get the amount defined in the worksheet "Ordem da Matriz" and fill the quantity respecting the limit of the column "Quantidade a Fornecer" until reset.

He would perform as well as the item RESISTENCIA 4KT example, the worksheet Ordem da Matriz", received 890 units and should distribute to affiliates as follows if done manually up to the 890, which remain at zero balance or you will be sent next consignment:
MATERIAL QUANTIDADE A FORNECER QUANTIDADE DISTRIBUÍDA
RESISTENCIA 4KT 1,00 1,00
RESISTENCIA 4KT 5,00 5,00
RESISTENCIA 4KT 6,00 6,00
RESISTENCIA 4KT 10,00 10,00
RESISTENCIA 4KT 18,00 18,00
RESISTENCIA 4KT 20,00 20,00
RESISTENCIA 4KT 30,00 30,00
RESISTENCIA 4KT 500,00 500,00
RESISTENCIA 4KT 10000,00 300,00



TOTAL 10.590,00 890,00

Could perform the same action on the worksheet "Repasse a filial" in order to remain easy viewing.