Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Selection 1 or the other
Is there a facility within Excel for making an external user answer a
question based on a critera he/she provided in a previous cell, and then respond based on the answer? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Selection 1 or the other
Possibly using Data Validation ..see
http://www.contextures.com/xlDataVal02.html but if you give an example of your rquirement, there are might be other alternatives. "Lazarus" wrote: Is there a facility within Excel for making an external user answer a question based on a critera he/she provided in a previous cell, and then respond based on the answer? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Selection 1 or the other
That solves the question part of it:D
Based on the second drop down (result of the indirect validation) Is there a way to alter existing data based on the answer?? IS A B 1 Drop1 Drop2 2 3 52 27 I want to add 1 to either A3 or B3 Based on weather the drop2 is responce1 or responce2.... I also would like the 1 to be taken away if the drop2 is then changed or cleared Thanks for the help so far Toppers "Toppers" wrote: Possibly using Data Validation ..see http://www.contextures.com/xlDataVal02.html but if you give an example of your rquirement, there are might be other alternatives. "Lazarus" wrote: Is there a facility within Excel for making an external user answer a question based on a critera he/she provided in a previous cell, and then respond based on the answer? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Insert Picture from dropdown selection | New Users to Excel | |||
Max Value in a column exclude selection - Excel VBA | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Edit Links: make update manual | Excel Discussion (Misc queries) |