hello

i have the following macro in "my workbook"

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Dim ofs As Long
If Sh.Name Like "P*" And Sh.Name <> Sheet17.Name Then
    ofs = CLng(Mid(Sh.Name, 2)) - 1
    Sheets("Master").Range("B10:P1009").Offset(ofs * 1000).Value = Sh.Range("B10:P1009").Value
End If
End Sub
what i would like...if in the range B10:P1009, the data is last reported on row 696, can the macro only consolidate the data in the master sheet of the active cells i.e. B10:P696?

my data is consolidated into the "master" worksheet, starting in cell B10....

can someone pls help!