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...
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.
Select A2 in your List sheet, then follow my instructions in my first reply.
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?