Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|