I need help with some formulas to make a master calendar/schedule linking all my projects to this schedule. I'm in construction and here is how my system is set up.... I do an estimate on a workbook, if that estimate turns into a job, I drop that file into another folder where my master accounting workbook is. I want to add a master schedule to this folder where all my jobs are tallied on a calendar. In my estimate workbooks, i have a cell for job duration and job start date. I want to like these to the master calendar to automatically get input to the right date slot on the calendar and for the duration that is specified. Is this even possible?
steve
Bookmarks