Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Input Validation Mark S[_2_] Excel Discussion (Misc queries) 5 February 24th 08 12:00 AM
Input Box data validation Mathew Excel Programming 7 September 6th 07 08:09 PM
How do I create a slider bar in Excel to control data input? P-15 Charts and Charting in Excel 1 April 5th 06 12:34 PM
Data Validation with additional input Shane73 Excel Programming 2 October 17th 05 06:59 AM
Data validation input message DT[_4_] Excel Programming 8 July 4th 04 12:16 AM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"