I have recorded a macro that copies data from a row of cells in one sheet and pastes them into another sheet. I made it so that it inserts a row for the next set of data. Is this the best way or is there a way to change the macro so that it just selects the next available free row to paste in the data in the second sheet.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy data from sheet 1 to 2 on a new line
- Thread starter apearson
- Start date
Similar threads
- Question
- Question
- Question
