Add row to below last entry.

[yatin1964]

Required macro for following action-
(Refer attached file)
Should have only one blank row (row no 10) below last entry (row no 9)
When Employee Code is entered in B10 in last row
One blank row should get added (alongwith formulae) below row 10 and above row containing Column Total
Sr. no in Column A to add up with 1
In last row of Totals, Formulae should incorporate newly added/deleted rows.

[Fotis1991]

When you fill with new data the last not filled row, you have to click Enter. Then run this code.

Please Login or Register  to view this content.

[yatin1964]

hi Fotis1991,
Thanks for the help, but the macro is not working.

Regards,

[Fotis1991]

You are welcome but just saying "macro not working" without any explanations...my reply is that macro works fine if you just follow the instructions..

[yatin1964]

1) Macro adds row above the current row.
2) Instead of adding Serial Number in Column A, Error shows up, up to row no#1000. ( I think this happens due addition of row above current row, but the nubring is done up to 1000th row instead of it should be up to newly added row at bottom and above the Totals row)