G’day,

My first post, here goes – I’m fairly new to learning VBA so any help at all on the following would be greatly appreciated.

I was curious how it’s possible to create a spreadsheet which has two functions…curious as I hoped to use a spreadsheet with the function:

A button at the top of the spreadsheet which adds a new sequential number to the next available row (I can do this part, but am struggling with the following part)…I would then like the numbered sequence to be inserted from a specific location i.e. set the first number to Column C, Row 10.
Then, each time the button is clicked, it will insert a new row (i.e. Column C, Row 11). As the new row is inserted, the cells will all be populated with a defined set of data i.e. a check box which triggers a count of adding 13, and a count formula for another cell.

Any help to support pulling the spreadsheet together would be greatly appreciated.