G'day,
I would like to set-up two cells under validation (with in-cell drop-down menus), where one is dependent upon the other's cell contents. I was going to make the source of the validation a list stored in other cells in my spreadsheet. To give you a better of understanding of what I am trying to achieve, in terms of validation dependency, I'll give an example. Say cell A1 has a validation list elsewhere on the spreadsheet that contains the entries "fruit, vegetables, take-away". Now depending on which of these is selected in the first cell A1, I would like to have the second cell, A2, choose a source list within the same sheet. For example if in A1, "vegetables" was entered, then a source list would be selected for A2 that may contain "potato, celery, carrot". I presume this requires some sought of IF statement in a macro, depending on the cell contents of A1. However, I guess my question is, how can I have this macro executed to set the validation source list for A2, once an entry (or choice) has been made in A1? Or is it possible do this by giving the cell's source range as a named range, and make it dynamic by inserting IF statements into its declaration in the macro?
If anyone can offer me any assistance I would greatly appreciate it!
Thanks in advance!
I would like to set-up two cells under validation (with in-cell drop-down menus), where one is dependent upon the other's cell contents. I was going to make the source of the validation a list stored in other cells in my spreadsheet. To give you a better of understanding of what I am trying to achieve, in terms of validation dependency, I'll give an example. Say cell A1 has a validation list elsewhere on the spreadsheet that contains the entries "fruit, vegetables, take-away". Now depending on which of these is selected in the first cell A1, I would like to have the second cell, A2, choose a source list within the same sheet. For example if in A1, "vegetables" was entered, then a source list would be selected for A2 that may contain "potato, celery, carrot". I presume this requires some sought of IF statement in a macro, depending on the cell contents of A1. However, I guess my question is, how can I have this macro executed to set the validation source list for A2, once an entry (or choice) has been made in A1? Or is it possible do this by giving the cell's source range as a named range, and make it dynamic by inserting IF statements into its declaration in the macro?
If anyone can offer me any assistance I would greatly appreciate it!
Thanks in advance!