Jump when copying a list of cells

[brainslick]

I have a spreadsheet with a list of 40,000 account numbers. I can only handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next batch.

What can I do to stop the jump?

 

[Luke M]

Instead of all that clicking and scrolling, try this.

Press Ctrl+g, then input the range of cells you want.

Or, you can type the range of cells you want directly into the name box (the
box to the left of formula bar)

 

[Don Guillett]

Try this idea to see how it works. Then change 20 to 40000 and change 4 to
whatever desired

Sub jumpdown()
For i = 1 To 20 Step 4
Rows(i).Resize(4).Copy
MsgBox i
Next i
Application.CutCopyMode = False
End Sub

 

[Teethless mama]

Let's say you want to select A1000:A3000.
In the name box type: A1000:A3000