Is there a way to group cells together? I am sorting data on one sheet and
this changes 1 column in another sheet. I need to have all data in a row
where the 1st column sorted to move with the value from the 1st column. If I
could group them together or somehow link the whole row then if the 1st
column changes the rest of the info in that row would go as well.

Any thoughts?

Thanks,
John

John,

In your rows, you need to have formulas (typically, VLOOKUP formulas) that extract the data based on
the value of the first column (if it is unique)....

HTH,
Bernie
MS Excel MVP


"johnrb7865" <johnrb7865@discussions.microsoft.com> wrote in message
news:F18BA643-CADD-47D4-B6AE-BACC7B61CF66@microsoft.com...
> Is there a way to group cells together? I am sorting data on one sheet and
> this changes 1 column in another sheet. I need to have all data in a row
> where the 1st column sorted to move with the value from the 1st column. If I
> could group them together or somehow link the whole row then if the 1st
> column changes the rest of the info in that row would go as well.
>
> Any thoughts?
>
> Thanks,
> John