Assuming you mean by the last column, the "real" last column, i.e. IV, and r is a variable
holding the current row number, r2 holds the fow number on the 2nd worksheet:

If IsEmpty(Cells(r, 256).Value) = False Then
Rows(r).Copy Sheet2.Cells(r2, 1)
End If


On Thu, 25 Sep 2003 02:58:23 -0700, "martyn" wrote:

If need to extract a row of information to another file or
workbook but only if the last column of that row is
populated. Im new to VBA so some sample code would be
excellent!
Many thanks