Excel 2007 : Calculate percentage with fixed total

Hello! I am in need of help! I've done a few searches, both here and on the internets, but I can't seem to find what I'm looking for. I don't even know if what I'm looking for is possible-or if I did find it, I'm not smart enough to recognize it...

I have a table with 9 colums (8 data, 1 for the total). I would like for the 8 data cells to total up to the fixed total cell. I would also like for these cells to be part of a percentage (percent sign doesn't actually have to be present).

so for example (imagine a pretty table here):

(in cells b2-J2) 20, 10, 20, 10, 20, 10, 5, 5 total=1860

1860=100%
I would like if B2-I2 could be manipulated so that someone could play around with the numbers (these numbers will never be above 100) and still have 1860 as the Max total.

Could you attach a sample workbook?

Here is a sample. The numbers 5-20 represent part of total percentage. 1860 is what the total is.

The attached workbook contains DATA VALIDATION in cells B2 to I2 that allows them to be manipulated but not exceed 100.

I don't see the data validation...I can still input greater than 100

you must insirt this

=B2*$J$2/100