Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. I am attempting to calendarize quantities across 12 months using some
type of automated function (as the start dates and quantities will change per project and I don't want this to be a manual function). I've gotten as far as "telling" the application that if a project duration begins in a particular month, to put quantities in the start month...but the kicker (problem) is that I don't know how to make the application spread the quantities over the other months (duration) of the project...for instance, a project begins in April and ends in June. I need to see 200 pages per month (project totals 600 pages with equal amounts of pages being completed over the 3-month period); the program reads that I need 200 pages in April, but I don't know how to get the rest of the pages for May and June to read--and then end at June...can anyone help? |