One way you may try is to record a macro while doing a manual
editFINDsort. Then modify.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ps.com...
I have a data dump into excel, but the info doesn't dump into the same
column everytime, so I need to search the sheet for that string and
once I find the column, use that column to sort the data.