Sorting Grouped & Non-grouped Rows

  • Thread starter Thread starter W.Gidzinski
  • Start date Start date
W

W.Gidzinski

Hi,

I have a worksheet listing all the tenants in an industrial business
park. The first row is column headings then each company's details are
listed....one company per row.

There happen to be several Industrial Malls/Multi-tenant buildings in
the park. For these I have grouped the individual tenants under the
owner of the Building(bold below). Each tenant has their own data and
the owner of the building (Company C below) display aggregate data from
all its tenants

Company A
Company D
COMPANY C (INDUSTRIAL MALL/MULTI-TENANT BUILDING)
...COMPANY E
...COMPANY F
...COMPANY H
Company B
Company G

I want to sort the sheet by company name and keep the groupings intact.
However when I sort by company name the group is not maintained and I
end up with the following:

Company A
Company B
COMPANY C
Company D
...COMPANY E
...COMPANY F
Company G
...COMPANY H

Ideally I would like to be able to sort like this, keeping the bolded
objects grouped:

Company A
Company B
COMPANY C (INDUSTRIAL MALL/MULTI-TENANT BUILDING)
...COMPANY E
...COMPANY F
...COMPANY H
Company D
Company G

Anyone have any suggestions?
Thanks
Wojtek Gidzinski
 
It might not sound appetizing, but if you put the owner on each row, you'll make
you're life a lot easier.

In fact, if each sub-company has multiple rows, it'll make life a lot easier
with that on each row, too.
 
Back
Top