List that are upside down

[Peter Bekkestad]

Hi,

I am struggling with a table that are getting new prices
each day in a worksheet. The new prices are added at the
bottom of the table (see first table below).

My problem is that I want to link my table to the
original table but with the last date at the top of the
list. For each new date, a new date and price is added at
the bottom of the original list, but I will always have
the last date and price at the top. The number of rows
(dates with prices) changes daily.

Anyone have any suggestion on how to solve this?


Peter
[email protected]

Original Data
2003-01-01 250
2003-01-02 240
2003-01-03 230
2003-01-04 240
2003-01-05 230
2003-01-06 210
2003-01-07 250


My list
2003-01-07 250
2003-01-06 210
2003-01-05 230
2003-01-04 240
2003-01-03 230
2003-01-02 240
2003-01-01 250

 

[Paul]

Hi,

I am struggling with a table that are getting new prices
each day in a worksheet. The new prices are added at the
bottom of the table (see first table below).

My problem is that I want to link my table to the
original table but with the last date at the top of the
list. For each new date, a new date and price is added at
the bottom of the original list, but I will always have
the last date and price at the top. The number of rows
(dates with prices) changes daily.

Anyone have any suggestion on how to solve this?


Peter
[email protected]

Original Data
2003-01-01 250
2003-01-02 240
2003-01-03 230
2003-01-04 240
2003-01-05 230
2003-01-06 210
2003-01-07 250


My list
2003-01-07 250
2003-01-06 210
2003-01-05 230
2003-01-04 240
2003-01-03 230
2003-01-02 240
2003-01-01 250

Can't you just sort the list on the date column, descending?

 

[Guest]

-----Original Message-----


Can't you just sort the list on the date column, descending?

The new price is added at different times, so I would
like to have the new dates and prices as soon as I get
the. (In addition do i have more than 20 dates and prices
that are in different worksheets).