I need to display the last entry of a column series from a worksheet in a
different cell, even if additional entries are inserted into that column
series.

For example, if series is A1:A10, then A10 needs to appear. If I insert two
rows between rows 1 and 10, the series will automatically expand to A1:A12,
and now I need A12 to appear.

Does anyone have a solution for this? I thought about creating a custom
function, but I only know how to do very basic functions, and this is over my
head.

Thanks for your help

Tory, have a look here, http://www.xldynamic.com/source/xld.LastValue.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Tory" wrote in message
...
I need to display the last entry of a column series from a worksheet in a
different cell, even if additional entries are inserted into that column
series.

For example, if series is A1:A10, then A10 needs to appear. If I insert
two
rows between rows 1 and 10, the series will automatically expand to
A1:A12,
and now I need A12 to appear.

Does anyone have a solution for this? I thought about creating a custom
function, but I only know how to do very basic functions, and this is over
my
head.

Thanks for your help

Paul B,
Thank you so much. That worked beautifully!

Tory

"Paul B" wrote:

Tory, have a look here, http://www.xldynamic.com/source/xld.LastValue.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Tory" wrote in message
...
I need to display the last entry of a column series from a worksheet in a
different cell, even if additional entries are inserted into that column
series.

For example, if series is A1:A10, then A10 needs to appear. If I insert
two
rows between rows 1 and 10, the series will automatically expand to
A1:A12,
and now I need A12 to appear.

Does anyone have a solution for this? I thought about creating a custom
function, but I only know how to do very basic functions, and this is over
my
head.

Thanks for your help