Move Rows to Another Sheet--- rows go to the bottom

KarlieBroad

When a project is complete we "move the rows to another sheet" so they are off the current project sheets but information is still available. The sheet we are moving the rows to is a duplicate of the original so all columns are identical. When I move the rows they go to the bottom (or close to) of the new sheet, how do I get them to go to the next free row? Finding them at the bottom and moving them is a nuisance. Thanks

Andrée Starå

Hi Karlie,

Try deleting all the empty rows that are between and then test to move from the other sheet again.

Hope that helps!

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Andree's suggestion is correct. Here is why...

 

The row is moving to the next UNUSED row. If a row was used but then the data deleted from the cells, it still registers as a used row. Deleting the empty rows will bring the next unused row up to also be the next visible row.

Dani_torrone

@Andrée Starå I tried deleting all the rows in-between and still nothing worked, the new inputs keep appearing on the bottom of the sheet (~row 1795). Do you have any other options for me?

Thanks so much!