Thanks Glenn. I really appreciate your getting back to me. When it comes to VBA, I am in the VB section only (Very Basic) and have no clue as to how it works. I am trying to create a simple cash flow model of a 4 phase housing project which consists of various tasks (for simplicity I am using months only) and have created a separate sheet for each phase. In each of these spreadsheets I have created a timeline chart for each task, so that cell C2 is the month a task (assume March 2011) starts and cell C3 is the number of months the task will take (assume 3 months) (Using EDATE and actual days). I have then put a formula into each of the relevant cells in the cash flow spreadsheet that divides the cost of the task by 3 and copied the formula into each of the relevant cells in the cash flow (assume that they are E10,E11 and E12. I am trying to find a way that will enable the cash flow to look at cell C2 to know that it must start in E10 and to then divide the cost of the task by the number of months in cell C3 and to do the same thing in cels E11 and E12 only, but if I change the values in C2 and C3 to say start in June 2011 and to run for 6 months that the cash flow will automatically recalculate to reflect the new start date and the new number of months that the cost must be divided over. If you can assist or point me in the right direction I will be most grateful. Cheers.
