Hi,

I have been attempting this but having no luck. I have sheet which I
copy info from A1:A9 to another sheet. Then I save and close that and go
back to the original sheet. I need to move down to row 2 and do all the
copy and paste again. There are about 300 rows and the exact last row
could change. How do I get this to move down to the next row until there
are none left?

Thanks