Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
I have a spreadsheet with a column of pull down cells. Using INDIRECT, each cell's menu options are unique, based on the answer is in the cell above.
Each individual response gets looked up in a table and a code isretrieved for that answer.
In one particular situation, if the answer chosen in Cell B12 retrieves a code of "S", i need to ask a lengthy question in Cell B13. I can put it in an In-Cell comment, but i only want to appear if the previous cells repsonse code as "s" . . . . maybe have a modeless window open if the response code is s?????
thanks
Each individual response gets looked up in a table and a code isretrieved for that answer.
In one particular situation, if the answer chosen in Cell B12 retrieves a code of "S", i need to ask a lengthy question in Cell B13. I can put it in an In-Cell comment, but i only want to appear if the previous cells repsonse code as "s" . . . . maybe have a modeless window open if the response code is s?????
thanks