Sort

[Ana via OfficeKB.com]

Hi!
In cells A1 to A20 codes of products, and in columns B to L associated data,
name, and some other data about it. In cells O1 to O20 I have also that codes
but in order that I want.
How to sort codes and associated data in columns A to L in the same order
like the codes in column O???
Please help!
Ana

 

[Luke M]

Go to Tools - Options, Custom list. In the box to import a list, input
$O$1:$O$20. Click Add.

Now, select all the data you want sorted, and go to Data - Sort. Click the
Options button, and then choose the custom list that you want to use as a
key. Then make sure you choose to sort by the A column.

 

[Ana via OfficeKB.com]

I did as you said but I get nothing, when I come to Add he just ignores me,
says "Cell without simple text were ignored." I also made a mistake by
telling I have A1 to A10 , but acctualy I have A1 to A520. Maybe that's the
reason?