hyerim
01-20-2008, 08:41 PM
Hi,
i try to develop training budget system using excel.
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
Can anybody help me with the formula to generate this?
i try to develop training budget system using excel.
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
Can anybody help me with the formula to generate this?