ROOTSMAGIC-USERS-L Archives

Archiver > ROOTSMAGIC-USERS > 2004-02 > 1076638852


From: Keith Thompson <>
Subject: Re: [RMagic] Master Source List Software or Spreadsheet???
Date: Thu, 12 Feb 2004 21:20:52 -0500
References: <JKEGIDJMFNCAMICMOGDLCEFGDIAA.jonesr007@hawaii.rr.com> <000501c3f1c2$fdcee510$0100a8c0@jimswinxp>
In-Reply-To: <000501c3f1c2$fdcee510$0100a8c0@jimswinxp>


As long as there are no empty columns or rows, you can click in one of
the cells within the database and it will expand to all of the
database. If you have headers in each column, it will definately
connect all and then be sure to mark that you have headers so that they
are not sorted with the data.

Keith Thompson

wrote:

>You must Highlight all the database first I believe, Data, Sort,
>Ascending/Descending, Choose which column to sort by, A,B,C, etc, then
>choose your secondary choice, and if you choose a third sort priority if you
>so choose.
>
>HAVE A GREAT DAY!!!
>
>Jim Mahan
>
>--- http://james.mahan.tripod.com
>--- http://wc.rootsweb.com/~jrmahan
>--- http://james.mahan.tripod.com/MCSIndex.htm
>
>--- "ALL INCOMING AND OUTGOING E-MAIL IS SCANNED WITH NORTON ANTI-VIRUS"
>
>----- Original Message -----
>From: "Wayne Jones" <>
>To: <>
>Sent: Thursday, February 12, 2004 3:21 PM
>Subject: RE: [RMagic] Master Source List Software or Spreadsheet???
>
>
>
>
>>Excel will do what you want -- set up the various columns you want, say
>>Date, Source No., Last Name, State, City, Address, etc. You can sort
>>
>>
>on
>
>
>>any three of them at a time -- say you wanted to sort by name, the city,
>>then state. to do this, clivk on the DATA command, then SORT, A window
>>pops up and you can pick out the colums you want to sort on -- in this
>>
>>
>case,
>
>
>>Name, City, then state. Your output will be all names, either forward or
>>reverse sort (according to your choice) So -- All the Jones would be
>>togetner, then all the Smiths, then all the Youngs. Then, on the next
>>
>>
>sort
>
>
>>criteria, all the Jones would be sorted by City -- Austin, Dallas,
>>
>>
>Honolulu,
>
>
>>etc. Then, on the final and last pass, all the citys would be sorted by
>>state -- so -- your final output wou;d look something like this:
>>
>>JONES, AUSTIN, Minnesota (if there is one), rest of row
>>JONES, AUSTIN, Texas, rest of row
>>JONES, Dallas, Texas
>>JONES, Dallas, West Virginia (if there is one)
>>JONES, Honolulu, Hawaii
>>
>>Of course, all the other information in the rows would follow along -- and
>>would be in order.
>>
>>Aloha
>>Wayne, NH6K
>>
>>-----Original Message-----
>>From: Beth Sullivan, DO [mailto:]
>>Sent: Thursday, February 12, 2004 12:45 PM
>>To:
>>Subject: [RMagic] Master Source List Software or Spreadsheet???
>>
>>
>>Does anyone know of a downloadable spreadsheet or simple software program
>>where I can maintain a chronological list of sources. I thought of an
>>
>>
>excel
>
>
>>spreadsheet with columns for master source number, surname, type of
>>
>>
>source,
>
>
>>original or copy, scanned into multimedia, storage place. I tried to make
>>one myself but I don't know enough about excel to get it to work like I
>>want. One of the things I want to be able to do is sort on different
>>
>>
>fields
>
>
>>and print lists sorted on type of source, surname etc.
>>
>>I looked at Clooz, but it was alot of money for more than I needed. A
>>
>>
>toned
>
>
>>down version might work better. There is a master list in Rootsmagic but
>>
>>
>it
>
>
>>won't let me sort it how I want and I can't print lists related to things
>>
>>
>I
>
>
>>still need to do.
>>
>>Beth
>>
>>
>>
>>
>>==== ROOTSMAGIC-USERS Mailing List ====
>>A very little help for the extreme computer challenged:
>>http://freepages.computers.rootsweb.com/~adelr/index.htm
>>basic HTML: http://freepages.computers.rootsweb.com/~pasher/
>>
>>==============================
>>Gain access to over two billion names including the new Immigration
>>Collection with an Ancestry.com free trial. Click to learn more.
>>http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>>
>>
>>==== ROOTSMAGIC-USERS Mailing List ====
>>RootsMagic-Users mail list Archives, Threaded:
>>http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/
>>
>>==============================
>>Gain access to over two billion names including the new Immigration
>>Collection with an Ancestry.com free trial. Click to learn more.
>>http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>>
>>
>>
>
>
>
>==== ROOTSMAGIC-USERS Mailing List ====
>RootsMagic is a FormalSoft product. The Formalsoft Home Page:
>http://formalsoft.com -- RootsMagic home page: http://www.rootsmagic.com/
>
>==============================
>Gain access to over two billion names including the new Immigration
>Collection with an Ancestry.com free trial. Click to learn more.
>http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>
>
>
>

This thread: