Forum Discussion
JimS-2145
Jan 15, 2020Copper Contributor
Adding Rows Without Losing Formulas
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. They are empty - the dropdown lists did not follow. Hope this question makes sense. Any ideas?
- This is your solution: https://www.youtube.com/watch?time_continue=57&v=18Mrb2mEtWs&feature=emb_logo
2 Replies
Sort By
- PascalKTeamIron ContributorThis is your solution: https://www.youtube.com/watch?time_continue=57&v=18Mrb2mEtWs&feature=emb_logo
- JimS-2145Copper Contributor
PascalKTeam Thanks. I had to go back and recreate my tables and data validations to get everything to work. Not sure why, but this video was helpful in getting it done. Thanks.