Copying a row based on date
 

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

Copying a row based on date
 

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
--
Gary''s Student - gsnu200803


"na" wrote:

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

Copying a row based on date
 

That worked - thank you very much!!

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200803


"na" wrote:

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