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.

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.