Jim, thank you. This somewhat helped. I had done this for the primary
sorter columns but not for the secondary. When I saw your link, I did it for
the secondary also and it sorted fine. For aesthetics, I put the "repeated"
entries in a white font so that it didn't "complicate" the look of the
spreadsheet.

Thank you very much.

Linda

"Jim Cone" wrote:

Linda,

You might also check out this approach from John Walkenbach...
http://j-walk.com/ss/excel/usertips/tip040.htm


Regards,
Jim Cone
San Francisco, USA

"Linda Mills" <Linda wrote in message
...
I have created a sales prospecting report that also tracks estimated revenue
over the next 16 months. For the revenue purposes, I am also tracking (in
separate rows for each project) estimated 1: revenue; 2: expenses: net with a
repeating header. All in all, for each project, I have 4 rows I want to keep
together in a sort.

Is there a way to do this in excel?