Sorting text and numbers from multiple tabs

[Jessabez]

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?

 

[Gord Dibben]

That's how Excel sorts.

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


Gord Dibben MS Excel MVP