I've tried multiple solutions to this common problem but nothing seems to work.

This list starts at B19 and I need to add a similarly formatted row at the end of the list when a button is clicked. I would very much prefer not to use the "List" function.

I have another list starting B23 (assuming there is only 1 line for the previous list) where I would like to do the same thing, but I assume it would need to be adjusted because the starting cell of the list might change.

I want to look at column B to find the end of the list because those are the cells that will always have a value in the list.

Any help would be greatly appreciated.

Thanks