I have to add rows to the spread sheet so I always copy and insert. This creates a new identical row so all I need to change is the serial number. The other 20 or so columns with data like addresses and model numbers can stay the same. There are thousands of rows in the spreadsheet and I may need to add a few or 2 dozen new rows somewhere in the middle. Copy and insert worked well.
Now I will have to create blank rows,then copy and paste special.