Macro to add a new row.

[fatpiggy123]

Hi,

I'm trying to think of a macro to add new rows under each seperate list in a spreadsheet. So far i've not had much luck.

I'm tring to have a button in each category that simply by clicking a new line is added at the bottom of that category ready to enter new information. I would idealy like it so the narrative on the very left is kept in its same place and not interupted by adding new rows.

I've attached a test doc to try help a little...

Many thanks in advance

[Leith Ross]

Hello fatpiggy123,

This macro has been added to the attached workbook. There are three buttons at the top of the page that will add a new line to each category. Here is the macro code.

Please Login or Register  to view this content.