List that are upside down

  • Thread starter Thread starter Peter Bekkestad
  • Start date Start date
P

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
(e-mail address removed)

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
 
Peter Bekkestad said:
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
(e-mail address removed)

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
Click to expand...

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


Can't you just sort the list on the date column, descending?
Click to expand...
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).
 
Back
Top