Creating a formula that references the last value of a column
 

Hey,
I was wondering if there was any way to create a formula that references the
last cell with a value in a column. This excel worksheet we have is updated
with a new value for the 2007 column every week, therefore we are just copy
and pasting our simple formulas one cell down each week. I was wondering if
there was any way to set a formula up that would just take the last cell that
has an entry in it and then start our formulas with that reference point. If
you need further clarification, just write back. Thanks.

Creating a formula that references the last value of a column
 

See replies at your other post.

Biff

"conny" wrote in message
...
Hey,
I was wondering if there was any way to create a formula that references
the
last cell with a value in a column. This excel worksheet we have is
updated
with a new value for the 2007 column every week, therefore we are just
copy
and pasting our simple formulas one cell down each week. I was wondering
if
there was any way to set a formula up that would just take the last cell
that
has an entry in it and then start our formulas with that reference point.
If
you need further clarification, just write back. Thanks.