I am going nuts trying to figure this out. I have a Excel Sheet where I have multiple lists where i add or remove from each list. I have a button that will add a row into a list but it won't autofill the data for me. The row numbers change so the autofill range needs to be based on the two list headers.
A B C D E F G
1 List 1
2
3
4 List 2
5
6
7
8 List 3
I need to be able to insert a row into List 1 or any other List and have it start auto fill after Header List 1 and end at List 2. I can't use row numbers because they will change as I add more.

Please Help