Moving rows

cswicegood

When I move rows from a master spreadsheet, beginning with row 1. My rows are moved to row 928. Do you have any ideas why this is happening?

Carson Penticuff

You likely have blank rows in the sheet you are moving to. Try deleting the extra blank rows at the bottom.

Jennifer Kurtz

Hi! Do you mean that on the Archive sheet where you're moving rows to, the rows with data begin at #928, and you have blank rows above it? If so, that can happen if data was cleared in the Archive sheet (e.g., if you were testing things out, then highlighted the cells and hit delete) - but the rows weren't actually deleted. If you delete the rows, then you'll remove that issue.

In general, though, I believe moving/copying rows from one sheet to another via automation will add the rows at the bottom of the sheet.

cswicegood

Thank you both I'll try this again.

cswicegood

I deleted all lines except line 1 on my sheet. This did work the data moved t line 2.