Need some help please
 

What I have so far is..
colum 1
number needed (order for year)
25% by supplier 1
75% by supplier 2

I then have a colum for each month Jan Feb Mar ect
it takes the number needed by 1/12th and puts total needed for each
month. That was easy enough..

But now what I would like to be able to do is this.... Say in January
the needed number changes.. I would like to have it set up to show what
would be needed from Feb to end of year by how many per month and not
change January figures I need to be at least a month ahead
on the order for one supplier and 3 months on the other..
each month has a formula

=1/12*B3 (B3 is number needed after the break down of each supplier)
supplier 2 is the one getting 75% of the work..... This is a long list
of part numbers and need an easy way to keep track
Hope that made sense
TIA
Tom