Sorting text and numbers from multiple tabs

  • Thread starter Thread starter Jessabez
  • Start date Start date
J

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?
 
That's how Excel sorts.

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


Gord Dibben MS Excel MVP
 

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

Similar Threads

Sorting day names chronologically 5
Auto sort help. 2
Sorting Macro 4
Sort Question 1
Sort column beginning with blank? 1
Amazon not accepting Visa Credit Card for payment from January 2022 20
sorting numbers 2
sorting with custom data 1

Back
Top