View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default can you group together rows to remain intact while sorting?

Add a helper column
Put numbers in this column
Row that must stay together, give same number
Use this as the first sort key
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"justusmomm" wrote in message
...
I have a list which needs to consilidated with another and then sorted
chronologically. I neede to lock or group together certain set of rows
please i am way past my deadline......thanks