Hi,
Here are some questions. I will very glad if someone can help me here.
Background:
1. Making a management review meeting template.
2. In each management review meeting, per project following needs to be done
a. Capture actual cost for the current week
b. Capture cost forecast for current week + 1, and current week + 2
c. Based on this, create table/chart for week-on-week cost data from the beginning of the project including forecast for the next 2 weeks.
3. For this template, I have created a excel file with 3 sheets
a. Data Entry sheet
b. Project Database sheet
c. Project Dashboard sheet
d. (Scratch - For intermediate calculations)
4. I am still working on Data entry and project database
5. I want to avoid VBA/Macros/ActiveX controls as much as possible.
Here are some problems I am stuck with:
Problem 1:
1. If a project is already in project database, when I enter project-id in the data entry sheet, rest of the fields in the data entry sheet should copy data correspondng to this project id from project database, leaving cost forecast cells for next 2 weeks empty.
2. If a project is new or not in the project database, when I enter (new) project-id in the data entry sheet, all the fields should get cleared (except project-id), a new entry should be made in the project database for this project id and after filling in the fields in data entry sheet, project database should get populated. (I am ok here if I need to add a simple button and a macro for this. But again, the button should be enabled only when it is a new project-id.)
Does anyone know - how to do this without using VBA/Macros/ActiveX controls? Form Controls are ok.
Problem 2:
1. Actual cost for current week and forecase cost for current week+1 and current week+2 is a running window over the 52 weeks of the year in project database sheet.
2. I know current week num and can use it to determine column for current week.
3. I know the row using project id.
4. When I enter the actual and forecast cost in data entry sheet, it should get copied in the right row and right column in project database.
Does anyone know - how to do this without using VBA/Macros/ActiveX controls? Form Controls are ok.
regards,
Jagmohan
Here are some questions. I will very glad if someone can help me here.
Background:
1. Making a management review meeting template.
2. In each management review meeting, per project following needs to be done
a. Capture actual cost for the current week
b. Capture cost forecast for current week + 1, and current week + 2
c. Based on this, create table/chart for week-on-week cost data from the beginning of the project including forecast for the next 2 weeks.
3. For this template, I have created a excel file with 3 sheets
a. Data Entry sheet
b. Project Database sheet
c. Project Dashboard sheet
d. (Scratch - For intermediate calculations)
4. I am still working on Data entry and project database
5. I want to avoid VBA/Macros/ActiveX controls as much as possible.
Here are some problems I am stuck with:
Problem 1:
1. If a project is already in project database, when I enter project-id in the data entry sheet, rest of the fields in the data entry sheet should copy data correspondng to this project id from project database, leaving cost forecast cells for next 2 weeks empty.
2. If a project is new or not in the project database, when I enter (new) project-id in the data entry sheet, all the fields should get cleared (except project-id), a new entry should be made in the project database for this project id and after filling in the fields in data entry sheet, project database should get populated. (I am ok here if I need to add a simple button and a macro for this. But again, the button should be enabled only when it is a new project-id.)
Does anyone know - how to do this without using VBA/Macros/ActiveX controls? Form Controls are ok.
Problem 2:
1. Actual cost for current week and forecase cost for current week+1 and current week+2 is a running window over the 52 weeks of the year in project database sheet.
2. I know current week num and can use it to determine column for current week.
3. I know the row using project id.
4. When I enter the actual and forecast cost in data entry sheet, it should get copied in the right row and right column in project database.
Does anyone know - how to do this without using VBA/Macros/ActiveX controls? Form Controls are ok.
regards,
Jagmohan
