Sorting Merged Cells


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

Advertisements

G

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

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top