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...
The cryptic structured references, along with the error you are experiencing, are the reasons why, like Bill Jelen, I am also not a fan of Excel Tables. See his article here:
https://www.mrexcel.com/excel-tips/i-am-not-a-fan-of-excel-tables/
https://www.mrexcel.com/excel-tips/i-am-not-a-fan-of-excel-tables/
Thanks, I finally got it to work. If the worksheet is named 'List' and the data is in column A row 2-10, the formula in the source box is =List!$A$2:$A$10 Unfortunately, if I add new items to the list it is not updated (I have Excel 2007). Evidently this has been addresses in version 2010.
Thanks, the formula you gave me in your 1st reply works great. By the way, you need another ) at the end for it to work. Still does not update the list when you add new items. It apparently does not re-count the lines when you add new items. Is there a way to re-calculate the formula automatically?
- Select A2 in your List sheet, then follow my instructions in my first reply.