Chello everyone,

I've been working on this project for 10 days now, it's roughly 90% done, but I've hit a bit of a snag.

Breaking it down:
1. Create a button. DONE.
2. When the button is clicked, insert a new row in a table. DONE.
3. The first cell of every new row should have a drop-down list.
4. The last cell of every new row should have an auto sum function that sums up all the cells in the row, except the first cell.

I've managed the first two well, my problem comes with the drop-down list and the auto sum function. I can't seem to get those to work. I've tried some different VBA code but it appears they only manage one of those elements.