Excel Filling rows automatically 1

[MJamison07]

I have a spreadsheet that looks like this with about 200 projects.

Proj No. Budget No. Months Jan Feb Mar...etc
1111.11 $100,000 10
2222.22 $50,000 5

I would like to have excel automatically fill in the rows to the right with the budget by month based on the number of rows.

so for project 1111.11 $10,000 ($100,000 ÷ 10) would fill in for 10 colums across and for Proj No. 2222.22 $10,000 ($50,000 ÷ 5)would fill in for 5 columns across. Sometimes the # months changes so I would also like excel to automatically adjust for that.

Is there a way?

Thanks
M Jamison

 

[xlhelp]

Assuming 1111.11 is in A2, 10K in B2, and 10 in C2; the formulai n D2 would be
=IF($C$2- COLUMN(D2)+3<0, "",$B$2/$C$2)

Member- AAAA Association Against Acronym Abusers

 

[MJamison07]

PERFECT!
Thank you!