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.

See replies at your other post.

Biff

"conny" <(E-Mail Removed)> wrote in message
news:5594E9A6-85B5-4ED0-9982-(E-Mail Removed)...
> 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.
>