View Single Post
  #6   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

It's OK. I've just munged my email address - hit reply, and then when
pormpted, remove the spaces, and change the dot to . Otherwise, you can post
your email address, though I would suggest you do it like: myfirstname dot
mylastname at blah dot com. I'll figure it out.

HTH,
Bernie
MS Excel MVP

"spbaechle" wrote in message
...
I just found the reply button, but I don't know how to contact you

privately.
Can you contact me? Can you please give me basic instructions on how to

do
what you say? Sorry I am such a beginner. Thanks.

"Bernie Deitrick" wrote:

If your two databases of names, etc., are sorted in a different order,

then
Chip's add-in will highlight everything. For example, if you add a new

item
into row 1 of a 2,000 row database, without making any other changes,

then
every cell will be highlighted as having changed (that is, if they are
unique values).

I have an add-in that isn't as polished as Chip's - it requires that the

two
sheets be placed into the same active workbook - but it does a database
style comparison based on a key value in a column. The end result is

that
the rows can be sorted differently (although the columns must be in the

same
order) and it will find true differences based on the key values. If

you
want the add-in, contact me privately and I will send it to you.

HTH,
Bernie
MS Excel MVP

"spbaechle" wrote in message
...
I have a spreadsheet list of names, addresses, phone numbers, & e-mail
addresses that I maintain for our class reunion. The Alumni

Association
has
a list that they keep on the web, but they can download it into Excel,
because that is where I got the spreadsheet in the first place. I

send
them
changes when I get them, but they do not send me changes when they get

them.
I would like to be able to have the computer compare them

automatically.
I
have had to do it manually before and it is really tedious and time
consuming. Is there a simple way to do this? I don't have much

computer
experience. I have just updated the spreadheet they gave to me.