Formula to display last few entries
 

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

Formula to display last few entries
 

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.


JAHanlon wrote:
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