custom sorting



Hello, I'd like to sort two lists of data which each contain multiple
columns of data for each record. I want to preserve the order of one of
the lists and sort the other list by it...

by the way, it doesn't seem to work when I do the tools custom list
way...I'm still forced to select a column to sort by after I specify
the key order and it will then just sort by the column rather than the
key list...

Bryan Hessey

If this is a one-off sort you could, on the list you wish to preserve,
include a column that contained the Row() number of each item, and
then, from the list you wish to sort, do a VLookUp and select that row
number. Sort the list on this vlook'd up value.

Hope this helps


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question