Sort
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1

Sort
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ana via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1

Sort
 

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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1