Okay, I've got a problem that's driving me crazy. I have an Excel spreadsheet that will be used by people to summarize data. In one column, there are only a handful of choices that could be entered. Therefore, I set up a Data Validation for that column. I created a sheet called Validation, and on it created the list of possible choices. As per the "Help" documents, I defined that range as a name. Now, the heart of the matter is this: in the next column over, the choices available again are limited, but contingent on the previous choices available. In simple terms I need this:
If value of cell = "Acount" use data validation with source name "=PracticeAccount" or if cell = "Access" use data validation with source name "=PracticeAccess"... and so on until all the first list choices are cycled through. Blanks are okay. I have it checked in the Data Validation pane.
Other issues that are driving me mad with this problem:
1. When I define the name in the Insert>Name>Define dialog, I set the range of cells that are allowed. It works for a little bit, and then Excel changes the values to some asinine value... same column, but like 65541 rows down.
2. I'm afraid to admit my ignorance, but what does the $-sign mean? The "Help" in Excel throws me for a complete loop. I know it's either the keep the cell value the same, or to move it to the next row (i.e. relative cell position), but I can't remember which. I ask because in the Source of the Data Validation, sometimes it's "$G$3, and sometimes it's $G3... both seem to change values however on down the line.
I apologize for the long post, but I hope the detail will help any of you masters give me the solution.
Thanks a bunch in advance,
=Daniel
If value of cell = "Acount" use data validation with source name "=PracticeAccount" or if cell = "Access" use data validation with source name "=PracticeAccess"... and so on until all the first list choices are cycled through. Blanks are okay. I have it checked in the Data Validation pane.
Other issues that are driving me mad with this problem:
1. When I define the name in the Insert>Name>Define dialog, I set the range of cells that are allowed. It works for a little bit, and then Excel changes the values to some asinine value... same column, but like 65541 rows down.
2. I'm afraid to admit my ignorance, but what does the $-sign mean? The "Help" in Excel throws me for a complete loop. I know it's either the keep the cell value the same, or to move it to the next row (i.e. relative cell position), but I can't remember which. I ask because in the Source of the Data Validation, sometimes it's "$G$3, and sometimes it's $G3... both seem to change values however on down the line.
I apologize for the long post, but I hope the detail will help any of you masters give me the solution.
Thanks a bunch in advance,
=Daniel