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