Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
how exactly does this grouping function work? does it only group those
specific cells? the reason i ask is that i have cells grouped, but now i want to sort them. and the grouping doesn't move with the data, it just stays. is there a way i can get the grouping to follow the data as it is sorted? thanks, steve |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Are you talking about merged cells? Or are you talking about Data--Group
and Outline? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "steve" wrote in message ... how exactly does this grouping function work? does it only group those specific cells? the reason i ask is that i have cells grouped, but now i want to sort them. and the grouping doesn't move with the data, it just stays. is there a way i can get the grouping to follow the data as it is sorted? thanks, steve |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Data/Group
"Anne Troy" wrote: Are you talking about merged cells? Or are you talking about Data--Group and Outline? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "steve" wrote in message ... how exactly does this grouping function work? does it only group those specific cells? the reason i ask is that i have cells grouped, but now i want to sort them. and the grouping doesn't move with the data, it just stays. is there a way i can get the grouping to follow the data as it is sorted? thanks, steve |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Then you should ungroup your cells before you sort again. Subtotals,
grouping/outline, and autofilters are really designed for temporary use. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "steve" wrote in message ... Data/Group "Anne Troy" wrote: Are you talking about merged cells? Or are you talking about Data--Group and Outline? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "steve" wrote in message ... how exactly does this grouping function work? does it only group those specific cells? the reason i ask is that i have cells grouped, but now i want to sort them. and the grouping doesn't move with the data, it just stays. is there a way i can get the grouping to follow the data as it is sorted? thanks, steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
grouping with vba | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) | |||
Grouping by day | Charts and Charting in Excel | |||
Grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) |