want a formula give total quanitity break up frm other sheet
 

I want a formula in excel by which if I put any quantity in cell it will give
its break down which is linked from any other sheet for e.g

total qty
30

Break up
6+6+6+6+6=30

when I type 30 it will give me its distribution from any other linked sheet.

want a formula give total quanitity break up frm other sheet
 

Why is the breakdown as shown and not (for example) 10+10+10 or 5+5+5+5+5+5?

"Aristotle" wrote:

I want a formula in excel by which if I put any quantity in cell it will give
its break down which is linked from any other sheet for e.g

total qty
30

Break up
6+6+6+6+6=30

when I type 30 it will give me its distribution from any other linked sheet.