grouping cells

[johnrb7865]

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

 

[Bernie Deitrick]

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