Macro to copy rows from one sheet to the next available row in another sheet

[gsjan1]

Once upon a time, I utilized this site for help in writing a macro that would copy data from one sheet into the next available column of another sheet. Today, I want to do something similar, except I want it to be the next available row. I pulled up the code from my successful column copy exercise and modified it by just trying to change the column references to row references. But, clearly that didn't work. help!

Thanks!

Please Login or Register  to view this content.

[stnkynts]

This portion is wrong.

Please Login or Register  to view this content.

By removing that bad code you will end up with code that is mostly correct

Please Login or Register  to view this content.

[alansidman]

After removing bad code, this worked for me.

Please Login or Register  to view this content.

[gsjan1]

This totally worked! Thank you so much!

[gsjan1]

Thank you so much for your help - it is sooooo appreciated! Have a marvelous day!