Sorting Merged Cells
 

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).

Sorting Merged Cells
 

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.

"Platinum girl" wrote:

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).

Sorting Merged Cells
 

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

"Joel" wrote:

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.

"Platinum girl" wrote:

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).