Hi ,
I am still not fully clear on what you wish to do.
1. Which cells have data entered in them ?
Are these columns B , C and E , F , G and beyond ?
If columns B and C are entered , column D can be calculated.
2. When you enter data in column E , there are two possibilities - either the value entered already exceeds the
Service Due value in column D , or it is less than the
Service Due value.
What is supposed to happen in the first case ?
3. After the value in column E has been entered , suppose values are entered in columns F , G and beyond. There are 3 possibilities -
- the sum of the value in column E and values entered in columns E , F , G and beyond is still within the Service Due value.
- the sum of the value in column E and values entered in columns E , F , G and beyond is equal to the Service Due value.
- the sum of the value in column E and values entered in columns E , F , G and beyond exceeds the Service Due value.
What is supposed to happen in each of the above 3 cases ?
4. If you want that periodically , the value in column E should replace the value in column C , then formulae cannot do the job ; you will need to use VBA.
Is this acceptable ?
Narayan