Forum Discussion

JimS-2145's avatar
JimS-2145
Copper Contributor
Jan 15, 2020
Solved

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

  • PascalKTeam's avatar
    PascalKTeam
    Iron Contributor
    This is your solution: https://www.youtube.com/watch?time_continue=57&v=18Mrb2mEtWs&feature=emb_logo
    • JimS-2145's avatar
      JimS-2145
      Copper 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.

Resources