Sorting text and numbers from multiple tabs
 

I have a master file I am working on in which data on one tab is linked to
other tabs. I have a macro for them to be sorted, but when I sort, only the
numbers sort and then the words are bumped to the bottom of the sorting
block. I end up with numbers sorted and then a huge gap with the words sorted
at the bottom. Any suggestions to fix this?

Sorting text and numbers from multiple tabs
 

That's how Excel sorts.

Numbers first then if your link formulas return "" they will appear then text.


Gord Dibben MS Excel MVP


On Thu, 3 Jul 2008 10:48:01 -0700, Jessabez
wrote:

I have a master file I am working on in which data on one tab is linked to
other tabs. I have a macro for them to be sorted, but when I sort, only the
numbers sort and then the words are bumped to the bottom of the sorting
block. I end up with numbers sorted and then a huge gap with the words sorted
at the bottom. Any suggestions to fix this?