Hi Pecoflyer,

You're talking to an oldie who's Excel knowledge is pretty basic. I thought about putting in a separate column with number 1, 2, 3 etc., and hiding that but how can I get the sheet to sort by that column. For clarity, there are other columns that rely on each row so when I insert the sort filter they all become live, so to speak. The only other column that I need to sort by is the alpha one, and that sorts OK. Looked at 'Sort By' and that might do the trick, but how would I go about inserting that based on the above.