Chris:
Not properly tested but here is a start:
In A1 there is a header (the word "date") in cells below (variable number) I
have some dates
In B1 there is a header (the word "item") in cells below (variable number) I
have some text
This formula displays the date 5 up from the bottom of column A:
=INDIRECT("A"&(COUNTA(A:A)-5))
Change the 5 to 4 and you get the one below that.
The corresponding text is displayed with =INDIRECT("B"&(COUNTA(A:A)-5))
Hope this helps
If you want the table on a different sheet use
=INDIRECT("Sheet1!A"&(COUNTA(A:A)-5)) assuming the original data in on
Sheet1

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:C02CEE2F-DCDA-43C1-9E72-A0DF5CB79412@microsoft.com...
>I have a table full of historical data which is updated week by week. I
>want
> to have another table that only shows the last 5 weeks worth of data and
> updates automatically each time the historical table is updated. Is this
> possible (or partially possible) in excel? If so, how do I go about doing
> it?
>
> Many thanks