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