Sorting Merged Cells

[Guest]

After reading many of the Q&A, it seems that it is preferred to NOT merge
cells as this causes problems. However, for various reasons, I need to do so
-- AND I need to be able to sort. Is there ANY way to do this short of
unmerging and remerging? Creative ideas are welcome (unless it involves
unmerging and remerging).

 

[Guest]

You can always write your own sort routines. They aren't too bad to write.
You still have problems if you want to look at data inside merged cells. I
wrote a routine last week where the sort key used names in column A. Each
name had 3 rows of data that had to be kept together.

 

[Guest]

Joel or anyone - can you help with how to write a sort routine...I am not
familiar with this.