Changing static code to dynamic code

Hi All,

I have some code here that I can't figure out.

The first code selcts 3 rows, inserts some more and then copies up the same format and clears certain areas. It does this for specific rows i.e. 31:33

The second code does the same but for only one row. This code however, is dynamic so when the rows change, it can follow down and insert the row inthe right place.

I need to combine these to so that I can select 3 rows and copy and paste and stuff but be dynamic to get it in the right place.

Any suggestions?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You can select multiple rows like this:

Please Login or Register  to view this content.

Thank you so much.
I was puttring the quotation marks in the wrong place!