Help with unusual table problem

[Howdy]

I would like to be able to add additional data to a table of approx. 2
rows and 4 columns. I would also like the newest data to be on to
while the remaining 19 lines all shift one row down and the leas
current row of data to drop off. I hope this explains my problem.

Thanks,

Howd

 

[Max]

Not sure if you might have missed my suggestion
to your earlier post yesterday in microsoft.public.excel.
( http://tinyurl.com/239sq )

Based on your "revised" specs in this post:

Let's say your table is in Sheet1 in A120
[assume an initial table size of 20 rows x 4 cols, say]

where new data is then progressively added
via new rows inserted right at the top
with "old" data pushed to the bottom

And what you want is to always grab / "show"
the "latest" / first 20 rows, i.e. what's in A120 of Sheet1

Try this in a new sheet, say Sheet2
------------------------------------------
Put in A1: =OFFSET(INDIRECT("Sheet1!$A$1"),,,20,4)

Copy A1 across to D1, then copy down to D20
(or copy down to A20, then across to D20)

A120 in Sheet2 will always return
what's in A120 in Sheet1
i.e. the "latest" 20 rows of data in Sheet1

So you can use A120 in Sheet2 as the "base" table
for any downstream purposes

 

[Max]

In Sheet1
-----------
you always have to *insert a row* BEFORE
you enter the most current data right at the top,
otherwise you'll just be overwriting what's in the 1st row.

Click on row1 header (or click on say A1)

Click Insert > Row

This inserts a new row,
and shifts existing data down by 1 row

Now you can enter the latest data in the "new" row1

-------------

The OFFSET table in Sheet2
will always reflect the "latest" 20 rows of Sheet1

--
Rgds
Max
xl 97
----------------------------------

To: <[email protected]>
Date: Fri, 30 Jan 2004 09:15:56 -0600

This is Howdy who you just gave some tips to on the
Excel forum.