Formula to display last few entries

[Guest]

Is there any way to take a summary worksheet and have it display just the
last, say, 5 entries into another worksheet? I have years worth of data in
one worksheet, and would like to have a running list of just the last few
entries in another worksheet. If it looks like this in worksheet1:

date letter letter
1/1 a b
1/2 c d
1/3 e f

In worksheet2 I want the last 2 entries off worksheet 1, but the next day
when I add 1/4, g, h, to worksheet1, I want 1/2, c, d removed and 1/3, e, f
moved up a row and then 1/4, g, h entered below it.

Is there anyway to do this?

Thanks for any help you can give. Andy

 

[Govind]

Hi,

In the second worksheet, have the following headers like your sheet 1

date letter letter

In the next row enter this formula for date, and copy it across for
letter columns

=OFFSET(Sheet1!A1,COUNTA(Sheet1!A:A)-2,0)

In the subsequent row enter this formula for date, and copy it across
for letter columns

=OFFSET(Sheet1!A1,COUNTA(Sheet1!A:A)-1,0)

These two rows will keep returning the last two rows in Sheet1. Just
make sure you dont have any blank rows in Sheet1.

Regards

Govind.