View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maarten B. Maarten B. is offline
external usenet poster
 
Posts: 1
Default fix rows together

Dear all,
I would love to do the following:
row1: Headaccount A
Row 2: Project 1 of Headaccount A
row 3:Project 2 of Headaccount A
Row 4: Headaccount B
Row6: Project 1 of Headaccount B

In the other collumns must be entered the values important for the
corresponding Headaccounts and projects. Now I want to fix every project with
its Headaccount, so when I want to sort ( by higest Value for instance), the
Headaccounts and projects stay together ( but are sorted per Headaccount).

Is there a way in Excel 2007 to achieve this?