Adding Rows Without Losing Formulas

[JimS-2145]

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?

[#2 · Accepted solution]

This is your solution: https://www.youtube.com/watch?time_continue=57&v=18Mrb2mEtWs&feature=emb_logo

[#3]

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