DOH! Of course, I do this.
List the names as you like in one column.
Assign a number in the next/another column from 1 to whatever to each name in the list.
This allows sorting by other columns and returning to your original arrangement by sorting the number column.
Steve N.
--- In ExcelVBA@yahoogroups.com, "Robert E. Carneal" <kentuckygenealogist@...> wrote:
>
> *Emphasis:
> * generate a number "weighted" based on a sort order
>
> any good?
> *
> Yes. Someone else made a suggestion that started my thinking. I think I
> started off over-thinking this and making it too hard. <g> I think by in
> the morning, I will have something workable that I can use, and not too
> hard to do. Thanks for your thoughts!
>
> **Thank you.
>
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar