Trying to make this Macro Apply to Every Populated Row??

Currently this macro will insert a row above the highlighted row and copy and past data from the above row into the new row and populate the last cell in the second row with "Shipping". Is there any way to make this apply to all populated rows in an excel sheet? or even apply it to 20 or 30 at a time?

Thank you in advance for any help!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Assuming your headers are in row 1, try this:

Please Login or Register  to view this content.