Hi,
I have a problem that I have not been able to solve. I am trying to create a list that cascades in a way similar to the windows start menu. I have read a number of posts on this forum about dependent lists, and have not been able to find the answer I am looking for.
If I am using the common example of countries and cities, I am looking for a solution that allows me to mouse over "USA", and then a sub list will appear to let me select "New York". I am looking for a way to wrap the whole selection process into one cell and not have to select "USA" from a list in cell A1, and then select "New York" from a list in cell B1.
I am working with Excel 2007, and have access to Excel 2003 if necessary.
Is the solution I am looking for possible? Any help is greatly appreciated.
I have a problem that I have not been able to solve. I am trying to create a list that cascades in a way similar to the windows start menu. I have read a number of posts on this forum about dependent lists, and have not been able to find the answer I am looking for.
If I am using the common example of countries and cities, I am looking for a solution that allows me to mouse over "USA", and then a sub list will appear to let me select "New York". I am looking for a way to wrap the whole selection process into one cell and not have to select "USA" from a list in cell A1, and then select "New York" from a list in cell B1.
I am working with Excel 2007, and have access to Excel 2003 if necessary.
Is the solution I am looking for possible? Any help is greatly appreciated.
