link data in a column to one cell
 

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

link data in a column to one cell
 

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

link data in a column to one cell
 

Thanks Sandy this was exactly what i was looking for and works the way i
hoped. Cheers for your help

"Sandy Mann" wrote:

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

link data in a column to one cell
 

You are very welcome. Thanks for letting us know that it was what you were
looking for.

--
Regards,

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
...
Thanks Sandy this was exactly what i was looking for and works the way i
hoped. Cheers for your help

"Sandy Mann" wrote:

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