Hi,
I have cells C5:C30 on one worksheet containing the names of people that are referenced from another worksheet (using ='Player Details'!$B5)
My problem is that if any of the criginal referenced are empty, i cannot sort the ones on the other worksheet in alphabetical order without excel sorting the blank cells first.
How can I get round this so it sorts the blank cells to the bottom of the list? Im presuming it's a job for a macro?
Thanks
Bookmarks