I am not sure how to explain my question. I have to enter in certain #'s that apply to each response that I was given. If I get 10 postive, 3 negative and 4 undecided, I have to enter them in like this.....

Positive - 1,1,1,1,1,1,1,1,1,1
Negative - -1,-1,-1
Undecided - 0, 0, 0, 0
(each comma is representing a different cell)

Then this will total up on a side bar. I was wondering If there was a way for me just to type 10 into the side bar and then have the 1's auto display through the certain cells.

Any help would be great, thank you.