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 wanted. Then tried Data Validation - did not work but closer to what I was looking for. I also use this workbook to track my credit card transactions and would like to use the same list table.

Data validation with a drop-down list is probably the best option and I'm wondering if you just missed a step & that's why it didn't work. Here's a video I made that explains how to do this, so hopefully that helps you accomplish what you're wanting to do: https://youtu.be/8sdFsXfj25Y

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:=TransactionNamesPress 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.

Twifoo 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.

input from drop down list | Microsoft Community Hub

12 Replies

Twifoo
Silver Contributor
Mar 10, 2019
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.
- prprewitt
  Copper Contributor
  Mar 12, 2019
  Thanks for the help. My list is a table named 'Transaction' in a sheet named 'ListTable'. Will that work as a dynamic named range?
  - Twifoo
    Silver Contributor
    Mar 12, 2019
    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.
sally365
Copper Contributor
Mar 08, 2019
Data validation with a drop-down list is probably the best option and I'm wondering if you just missed a step & that's why it didn't work. Here's a video I made that explains how to do this, so hopefully that helps you accomplish what you're wanting to do: https://youtu.be/8sdFsXfj25Y

Forum Discussion

input from drop down list

12 Replies

Resources