Macro - inserting multiple rows

[douglaswarden]

Hopefully this will be a straightforward query, but I am a novice when it comes to writing macros.

Please see the attachment.

You will see that I have recorded two macros:

1) To insert a new row for new people.
2) To insert a row for new animals.

With regards to 1), I would like to create a macro that copies the contents of the row with the penultimate name in the people section, and for a new row to be inserted beneath the copied cell.

Similarly, with regards to 2) I would like to create a macro that copies the contents of the row with the penultimate name in the animal section, and for a new row to be inserted beneath the copied cell.

The issue that I have is that the macros do not copy the penultimate cell in each section, but copy a particular row, say row 11 each time I want to insert a new animal. So if I had inserted numerous new rows for the people section, and subsequently wanted to insert a new row for the animal section, I press “crtl+sht+a” which copies the contents of row 11 and which is not the contents of the penultimate row for the animal section.

Please can you let me know how I should amend the macros.

[Richard Schollar]

Hi

Please see attached. I have named two ranges on your sheet (Animals and People) - please review b7y going Insert>Name>Define.

Code for both macros is basically the same:

Please Login or Register  to view this content.

Richard

[douglaswarden]

Many thanks Richard. Works perfectly.