grouping cells

  • Thread starter Thread starter johnrb7865
  • Start date Start date
J

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
 
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
 
Back
Top