Linking changing values (cells) between worksheets.

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.

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tumbleweed" <Tumbleweed@discussions.microsoft.com> wrote in message
news:8563E828-2064-4BE0-BFEF-189A8571EA84@microsoft.com...
> 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.

> .. (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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---

> .. (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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tumbleweed" <Tumbleweed@discussions.microsoft.com> wrote in message
news:8563E828-2064-4BE0-BFEF-189A8571EA84@microsoft.com...
> 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.