Linking changing values (cells) between worksheets.

T

Tumbleweed

How can I create a link from a column in one worksheet to another cell in a
worksheet. More specifically I have a column of dates and then a column of
values tied to those dates. I want to link to the last value entered in that
column, so as the last value gets added each day. I want that link to show
the updated value on the other worksheet.
 
M

Max

One way ..

Assuming in Sheet1, the col of dates (real dates) is in col A, values to
return in col B, and the dates / values are progressively entered down the
cols (i.e. dates in col A are not entered ahead of values in col B)

In Sheet2, we could put in say, B2:

=INDEX(Sheet1!B:B,MATCH(LOOKUP(9.99999999999999E+307,Sheet1!A:A),Sheet1!A:A,
0))

which should return the value in col B in Sheet1 corresponding to the latest
date entered in col A
 
M

Max

.. (i.e. dates in col A are not entered ahead of values in col B)

Above should read clearer? as:
(i.e. dates in col A are not pre-entered way ahead of values in col B)
 
Top