Updates to line number 1000 and then again from 1 to 1000 again

[marreco]

Hi.
In a flap with teacher groups of values​​, each value is updated by internet.
I have tabs with each group of values ​​needed when updating the master tab, tab group is added to this value, and when there is another update updates on the line below, up to 1000 lines would update this, then she would return to first line.

When updates tab called "ATUALIZAÇÃO"
line fills the time and date information from the internet
when you get back to the line 1.ooo THE FIRST line

See my fileOne Row to 1000 row.xlsx

[Excel Fox]

marreco, not sure, but is this what you are looking for?

Sub DoAgain1000()

    Dim lng As Long
    
StartOver:
    For lng = 1 To 1000
        If IsEmpty(Range("D7").Resize(1000).Cells(lng)) Then
            'fill that row with data
            Exit For
        End If
    Next lng
    If lng = 1001 Then
        Range("D7").Resize(1000, 4).ClearContents
        GoTo StartOver
    End If
    
End Sub

can't understand exactly what are you asking for. Can you be a little more clear please.

[marreco]

Hi.

in the range of "D7: G2" spreadsheet "ATUALIZAÇÃO" is prenchido for data, then the interval "D7: G2" spreadsheet "data1" to be iqual interval "D7: G2" spreadsheet "0ATUALIZAÇÃO"

If the data in the worksheet "ATUALIZAÇÃO" pass line 1000 then ...

in the range of "D1001: G1001" worksheet "ATUALIZAÇÃO" is prenchido by data, then the range of "D7: G7" worksheet "data1" is the interval iqual "D1001: G1001" worksheet "ATUALIZAÇÃO"

If the data in the worksheet "ATUALIZAÇÃO" pass line 2000 then ...
in the range of "D2001: G2001" worksheet "ATUALIZAÇÃO" is prenchido by data, then the range of "D7: G7" worksheet "data1" is the interval iqual "D2001: G2001" worksheet "ATUALIZAÇÃO"

ie the worksheet "data1" I'll have a range of 1000 lines.
But I need to get the last 1000 lines filled in the worksheet "ATUALIZAÇÃO" because it acada minute worksheet "ATUALIZAÇÃO" is filled then it will contain many rows filled.
Thank you!!

[littleiitin]

What I understand, you want only last one thousand rows in your main sheet and complete data in Data1 sheet.

Am I Correct?

Thanks
Rahul

[marreco]

Hi

yes!!!

Thank you!!

[marreco]

Hi.

Anyone helpe please.

thank you!!!

[Charles]

HI,

I'm looking at your project. But still confused as to what you want.
Could you supply a more detailed info and expand the sample workbook you provided.
That is show a short sample of the fist 1000 then where you want the next 1000.

[marreco]

Hi.

Yes!

[Charles]

marreco,

I'm still waiting for a better example of your request.

Could you supply a more detailed info and expand the sample workbook you provided.
That is show a short sample of the fist 1000 then where you want the next 1000.