[libreoffice-users] Need Calc help

Hi,

Hopefully someone can help me out.

I maintain in Calc the regional section of a National membership file of 
Alumni. There are about 650 members in my regional Calc file.

Each record is keyed to an unique College number and consists of about 
26 fields of data including First/Last names, address, telephone number, 
etc.  On a monthly basis, the national office sends me a 'pull' in Excel 
format from their national database.  Since changes, additions, and 
deletions are not annotated by National, I have to manually compare each 
record in the latest listing with the appropriate record in my files. As 
you can imagine, doing this manually takes a long time when there are 
about 650 records involved.

Assuming that the Column headers are the same in both files (not 
necessarily in the same order), is there a way that I can compare the 
two files to create a listing by College Number of fields that do not 
agree, and records that have been deleted or added?

I am computer savvy but failed programming miserably so I need the input 
of the many smart people on this list.  I do follow instructions well so 
could be led by the nose to create what is required.

Thank you for your patience and help

Preston



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted