Forum Discussion

prprewitt's avatar
prprewitt
Copper Contributor
Mar 08, 2019

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...
excel
Twifoo's avatar
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.
prprewitt's avatar
prprewitt
Copper Contributor
Mar 19, 2019

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.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 19, 2019
    Press Ctrl+Alt+F3, then in the Refers to box, enter the formula for the defined name.
    • prprewitt's avatar
      prprewitt
      Copper Contributor
      Mar 19, 2019

      Twifoo 

      In order to experiment with Data Validation, I created a new workbook with a worksheet named 'DV' that contains a table with (3) column headings; DATE, TRANSACTION & NOTE.  I added a 2nd worksheet named 'List' that contains a table with the heading 'LIST' and several sample transaction names.  Both tables were created using 'Insert > Table...'

       

      I successfully created a dynamic list named 'DLIST'.  When I type =DLIST in the source box I get a 'Source evaluates to an error...'.  If I type =List!DLIST (I am thinking that it could not find the worksheet with the DLIST) then I get a 'Cannot reference other worksheet...' error.

Resources