Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Issues
I have an excel workbook that is used to select available services on one tab,
and transfer the services with a quantity greater than 0 (and therefore will be on a customer's bill) to a second tab. Some services are only available if another service is selected- ie: you can't have voicemail without a phone, and you cannot have two voicemails with only one phone. Therefore, I put a validation on the dependent cell to be less than or equal to the control cell. After all quantities are entered, the user then sorts and the cost sheet is populated by any row with a quantity greater than 0. The problem arises at this point. Upon sorting, the validation no longer functions, and I need to retain this validation. Some things I thought of are populating the cost sheet with only the values 0 without sorting, or using a filter. Any ideas? ? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200605/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
Copy workbook- Validation function | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |