Forum Discussion
input from drop down list
I created a check register table that I would like to select the transaction name from a drop down list that uses a table from a separate sheet. I have looked at combo and list box - not what I want...
Assuming the label in A1 is Transactions and your list starts in A2, define TransactionNames as a dynamic named range for your list with this formula:
=$A$2:INDEX($A:$A,COUNTA($A:$A)
To create the drop-down list, press Alt,A,V,V then in the Source box, type:
=TransactionNames
Press Enter and you’re done.
=$A$2:INDEX($A:$A,COUNTA($A:$A)
To create the drop-down list, press Alt,A,V,V then in the Source box, type:
=TransactionNames
Press Enter and you’re done.
Thanks for the help. My list is a table named 'Transaction' in a sheet named 'ListTable'. Will that work as a dynamic named range?
- You have to test it by adding new items to the list and see if the new items are included in the drop-down list. If included, then your list is dynamic.
Thanks again for your help. As I go through the steps to add the drop down list using data validation, it will not let me go to the sheet where the list is. Also, where do I input the formula you gave me earlier? I have made many careful attempts with no success.
- Press Ctrl+Alt+F3, then in the Refers to box, enter the formula for the defined name.