Thank ou for coming back to me so soon.
The information comes in via sheet one Maintenance report and sheet two Quote Report and I am trying to basically do the same formula and data translation so it appears in Month order on sheet three "Cash Project Forecast.
Sheet four is only what I have created in order to try and solve the problem and put a numerical value against a date.
Now starting with Sheet 1 line two - "column C" contains the date I am interested in but it can be any day in any month and the report is unfiltered. The Value of the job is shown in "column J"
What I am trying to do is that when the report is dropped in on sheet one I would like Excel to decide that the dates in Column C on each line are within a particular month and then insert the value shown on Sheet One Column C onto sheet 3 under the correct month with the correct value.
1.Sheet1:Line2 :Column C, Response In - Sheet3:Line7:Column M, Value Inserted £4000
2.Sheet1:Line3 :Column C, Response In - Sheet3:Line8:Column O
Value Inserted £8500
3.Sheet1:Line4 :Column C, Response In - Sheet3:Line9:Column K
Value Inserted £1050
Hope this assists