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