Copying a row based on date

[na]

worksheet 1 contains rows of data including a column of dates - I want to
link the row with the latest date into a row in worksheet 2

 

[Gary''s Student]

Say Sheet1 has dates in column A. The latest date is the max value (cause
dates are just numbers). We find the max in column A and use OFFSET() to get
the rest of the row:

=OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1!$A:$A)-1,COLUMN()-1)

and copy across

 

[na]

That worked - thank you very much!!

Say Sheet1 has dates in column A. The latest date is the max value (cause
dates are just numbers). We find the max in column A and use OFFSET() to get
the rest of the row:

=OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1!$A:$A)-1,COLUMN()-1)

and copy across