i have a spread sheet where i have to record some events. the first row is
already formatted and the first cell of the row has a number 1.
i would like a macro to automatically create another line each time a press
a button and that would increase the number of the first cell from the
previous line.

numberheader2 | header3
--------+---------+---------
1 | bla bla | zzz zzzz
2 | qwfjkd | jjioeereorko
3 | gdfgfgf | frefsdfdf

i would like a macro that associated to a button automatically add a line
below the last one, keeping the same formatting of the cells and in the line
added increase the column "number" by 1

in order to have:
number | header2 | header3
--------+---------+---------
1 | bla bla | zzz zzzz
2 | qwfjkd | jjioeereorko
3 | gdfgfgf | frefsdfdf
4 | |