ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to control data input useing validation (https://www.excelbanter.com/excel-programming/423105-how-control-data-input-useing-validation.html)

Balachandran

How to control data input useing validation
 
Dear all

I am having a requirement.

While doing the budget format for 9-10 we have mandays budget. Utilization
of the man power is to various activites say 20 to 30 activites. I want to
restrict the operator not to exceed total mandays planned to mandays budgeted

I will elaborate

Let c10- Mandays budgeted 300

at c20 to c50 detailed plan for utilisation of the labour to various
activities

ie. c20 Vechicle celaning 10
c21 Helper to celaner 10
c22 ---- 10
c23 --- 5 so on

When the person doing the budgeting tries to enter at c21 he shall be
promted that mandays left is only 290-- and so on ( 300-10)

Thanks in advnce





--
bbcnair


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com