In sheet 1, i have the training schedule as below:
Course NamePerson 1Person 2Person 31Course 1 20082Course 220083Course 32008
In Sheet 2, i hv budget summary:
Actual Budget200,000.00Budget Utilised to date0.00Balance200,000.00
What i want to do is, when i assign date in the schedule as below,i want to automatic calculate the course fee in the summary sheet. Let say, fee for course 1 is $1,500 and course 3 is $ 1,000,so when i enter the date for the course, the summary sheet will be like sheet 2:
Sheet 1
Course NamePerson 1Person 2Person 31Course 1 13-14 Mar 082Course 220083Course 312-14 Feb 08
Sheet 2
Actual Budget200,000.00Budget Utilised to date2,500.00Balance197,500.00