Distribution of Forecast values by reducing from the last column

[velu130486]

Dear Seniors,

First of thanks for your support, with help of this site I had sorted out my earlier problems in macros. Now I am facing the new problem which I am expecting the support from you.

I am working in a project where i have the deployment plan for more than 1500 people. As you know actual deployment will not be same as plan. So every month I update the actual in different columns, Once I updated the same I need to re forecast the planned values.

1) When the Actual Man hours spent are more than the plan, then difference should be deducted from the last cell towards start till Plan and Forecast man hours are equal. If there is no future plan then the variance man hours should be copied in different column.

2) If the actual Man hours are less than the plan, then forecast should be kept same as plan, however difference man hours should be copied in different column.

Here Plan means, Man hours should check the total at every month end and compare the total. I managed to do the same with formula with some fixes yet to be done say if the actual man hours are more than the plan, variance man hours appear immediately in the forecast column instead of separate column, and i believe this can be done only with macro.

May be my explanation is not clear, so I have uploaded the sample file in the following link.
https://drive.google.com/file/d/0B-gqVByC6OGQTWtQbS1tcXNGQm8/view?usp=sharing

Many thanks for your support

Regards
R. Vadivelan

 

[velu130486]

Dear Excel Gurus,

Please help me to solve this issue. I already created macro for distributing the difference value at the last column with help of my friend, but now I need your support to reduce the difference value from the last month for each person.

I had enclosed the sample file with macro code.
https://drive.google.com/open?id=0B-gqVByC6OGQb2hZYUZlRTJaajQ

Regards
R. Vadivelan

 

[velu130486]

Dear Excel Gurus,

Please help me to solve this issue. I already created macro for distributing the difference value at the last column with help of my friend, but now I need your support to reduce the difference value from the last month for each person.

I had enclosed the sample file with macro code.
https://drive.google.com/open?id=0B-...2hZYUZlRTJaajQ