Excel 2007 : Question about auto populating

[toneloc1148]

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.

[TMS]

If the nunber is in cell A1, put the following formula in cell B1 and drag across:

=IF(COLUMN(B$1)-1<=$A$1,1,0)

So, if A1 has a value of 10, you'd get 1 in cells B1 to K1 and zeroes after that.

Alternatively, for spaces:

=IF(COLUMN(B$1)-1<=$A$1,1,"")

Regards