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.
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.
I am adding new rows at the bottom. Essentially I have a worksheet of customers. I have created dropdown lists for different columns, such as region and industry. I made this worksheet into a table so as I add a new row/customer, the table design would continue and ideally so would the dropdown lists. The table design does continue/expand......however, the cells that should have the dropdown lists do not, and the "=A$6" does not either. They are empty - the dropdown lists and "=A$6" did not follow. The question goes beyond the "=A$6".........it's more about properly converting my worksheet into a table so formulas and dropdown lists will continue as I add new rows/customers at the bottom. Thanks.
JimS-2145 Difficult to resolve without the worksheet "in-hand".
Riny_van_Eekelen I went back and recreated all of my tables and validations and now it works. Your solution for creating a default answer was perfect and a lot easier than other visual basic solutions I've read. Thanks.