Forum Discussion
Creating a default value from drop down list
You could have the validated cell point at the first cell in the list. Suppose your list populating the dropdown starts at A6, you could enter:
=$A$6....in each cell that requires validation. Example attached.
You could have the validated cell point at the first cell in the list. Suppose your list populating the dropdown starts at A6, you could enter:
=$A$6....in each cell that requires validation. Example attached.
Riny_van_Eekelen Thank you. Simple and effective. One more question you may know. How do I get this to persist as I add rows with new customers?
Not sure I follow. You mean that you want to expand the range that populates the drop down?
Riny_van_Eekelen I have a long list of customers. I was successfully able to add your solution to the existing rows. Thank you! The challenge I am having now is when I add a new row/customer to my list, which is in table format. The =$A$6 doesn't copy into the cell when I add the new row. I realize this is an issue unrelated to the initial question, but something I will need to solve. Thanks.
Not sure I follow. Are you inserting above A6? Then the cell under your drop down will point A7, despite the dollar signs.