adding row

M

massi

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 | |
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top