Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping cells
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 is 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping cells
Name the range, then reference the named range in your calculations/sorts....
"johnrb7865" wrote: 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 is 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping cells
You could also use the values in the column that changes for a VLOOKUP. That
would keep the correct data associated, regardless of how your one column of data got arranged. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "TWhizTom" wrote: Name the range, then reference the named range in your calculations/sorts.... "johnrb7865" wrote: 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 is 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping cells
On Jul 21, 2:16 pm, johnrb7865
wrote: 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 is 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 First, the data doesn't "move". That means something else in Excel, you'll want the correct terminology. You have a "reference" on the 2nd sheet that changes when the 1st sheet changes. You apparently have formulas in the 1st column on the 2nd sheet in order to do this. If you want more columns to match the first sheet, you need formulas in those columns, as well. Since you are using Sort on the first sheet, some types of formulas could get messed up, but VLOOKUP won't. So take M Kan's suggestion. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping two cells together | Excel Discussion (Misc queries) | |||
Grouping Cells / Sorting | Excel Discussion (Misc queries) | |||
Grouping like coloured cells | New Users to Excel | |||
Grouping or locking cells | Excel Discussion (Misc queries) | |||
Grouping cells | Excel Discussion (Misc queries) |