On Oct 3, 2011, at 6:40 AM, Dotan Cohen wrote: > I am reviewing the records of a local shop to help him convert to Open > Office. I have found no problems with the simple Word documents that > he uses, but he is using MS Excel where he should have a real > database. We all know about efforts to teach an old dog new tricks, so > let's just be glad that he is interested in this new trick called Open > Office. He will _not_ be moving to Base or anything else, it will be > either in Excel or another spreadsheet. > > In this particular case, he has information that should be in a single > row (record) divided into to rows, with the A column's cells merged > between the two and the "sorting key" stored in that cell. He now > wants to sort based on the merged cells, keeping the dual-row records > intact. > > Example: > --------------------------- > 1 | Some info > | More info > --------------------------- > 3 | Yet some more info > | And more info > --------------------------- > 2 | Some important info > | More important info > --------------------------- > > He now needs to sort that! Does anybody know how this can be done? > Trying the regular sort function returns an error that range > containing merged cells can only be sorted without formats. > > Example document here: > http://dotancohen.com/images/examples/sort-example.ods > > Thanks. > > -- > Dotan Cohen > > http://gibberish.co.il > http://what-is-what.com > -- > ----------------------------------------------------------------- Write a macro to do the sort.
BTW the example you attached was really helpful to understanding. -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
