Help with tables

  • Thread starter Thread starter Howdy
  • Start date Start date
H

Howdy

Assume a table of 25 rows of data. Enter new data, maintain 25 rows
having newest data in table and least current data out of table. Need
to show in table current 25 rows of data. Enter new on top and oldest
at bottom.

Thanks,

Howdy
 
Let's say your table is in Sheet1 in A1:C25
[assume an initial table size of 25 rows x 3 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 first 25 rows, i.e. what's in A1:C25 of Sheet1

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

Copy A1 across to C1, then copy down to C25
(or copy down to A25, then across to C25)

A1:C25 in Sheet2 will always return
what's in A1:C25 in Sheet1
i.e. the "latest" 25 rows of data in Sheet1

Depending on the number of cols your actual table contains
(the example above assumes 3 cols), just:

Adjust the width ("3") -the last parameter in the OFFSET- to suit
and also adjust the "copying across" accordingly
 
Back
Top