If you mean that you have a range of cells being progressively filled in and
you want the last entry to show in another cell then try:

=LOOKUP(1,1/(E12:E21<""),E12:E21)

This will work if there are no gaps in the range, if there are gaps, (ie
spaces), then try:

=INDEX(E12:E21,MAX((E12:E21<"")*(ROW(E12:E21)-ROW(E11))))

This is an array formual and must be entered with the Ctrl & Shift keys held
pressed while you press enter. If doen correctly then XL will put curly
bracres { } aroint the formula.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Brian M" wrote in message
...
Is there a way to link one cell to a group of cells so that the
information
input in the next corresponding cell of the group overides the information
showing in the linked cell, but will still keep the data in the columns.

Hope this make sense,

and cheers in advance

Regards

Brian m from sunny scotland