Loop through sheets with Name starting with AIPRSU to add a new row with data from row 2

[Beck82]

Hello!

I need to have a macro to loop through sheets with Name starting with AIPRSU to add a new row under the headers (so the new row should appear in position 2) and this new row should be filled with data from the previous row 2 (which will then become row 3).

So to recap:
- The macro should loop in each sheet starting with name "AIPRSU"
- For each sheet, create a new empty row right under the headers' row
- the new empty row must be filled with the same data contained in the row right below this new empty row (which is the line that was previously occupying the new empty row's position)

Attached you can find the template I am working on.

Many thanks !

F

[carlmon]

Give this a whirl

Please Login or Register  to view this content.

[Beck82]

Thanks,
I get an error when running this macro, it says "Object Required".
Moreover, do you happen to be able to implement also the copy of data from the other row as mentioned in my post? It seems to be missing in your coding.

Thanks!
F

[carlmon]

My apologies, this will work. Coffee hadn't kicked in yet. Also, this will make a duplicate row (row two will now equal row 3)... if that's not your intention, let me know

Please Login or Register  to view this content.

[Beck82]

Thank you very much! This solution worked perfectly!

[carlmon]

Great! And thanks for the rep