SORTING

[lehigh]

Hi All

I copied & pasted 2 seperate company lists from web sites. One under
the other.
The company names reside in column E
One of the lists has scattered information in columns A thru D
The other list has NO information in columns A thru D

My first record is on line 5
My last record is on line 1,684

I highlighted every cell from A5:AR1684
Then I selcted sort by Column E w/ no headers

A few lines sorted within each of the lists but the 2 lists never
meshed.

What did I do wrong?


Thanks for any help you can give me

Tom Snyder


WINDOWS XP - PRO
EXCEL 2002 SP-2

 

[Ken Wright]

If you do this often, you should put a copy of Dave McRitchie's Trimall macro in your personal.xls
file. This will clear all that garbage out from your data:-

http://www.mvps.org/dmcritchie/excel/join.htm#trimall