Sorting Merged Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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.
 
Joel or anyone - can you help with how to write a sort routine...I am not
familiar with this.
 
Back
Top