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. I cant sort the list I
do not know when the new date and prices are added. In
addition are there a lot of lists (about 20) that I link
data from.
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
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. I cant sort the list I
do not know when the new date and prices are added. In
addition are there a lot of lists (about 20) that I link
data from.
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