Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel should be able to compare 2 spreadsheets to find differing .
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. |
#2
|
|||
|
|||
Hi
goto: http://www.cpearson.com/excel/download.htm and search for "Compare" http://www.cpearson.com/Zips/Compare.ZIP -- Regards Frank Kabel Frankfurt, Germany "spbaechle" schrieb im Newsbeitrag ... I have a spreadsheet list of names, addresses, phone numbers, & 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. |
#3
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
I downloaded Compare.zip, but I can't figure out how to open it. It says it
is a macro, but then the button says "disable macros" and when I click enter to get the default options it doesn't open it. What am I doing wrong? Or, what should I be doing? Sorry I don't understand this stuff. "Frank Kabel" wrote: Hi goto: http://www.cpearson.com/excel/download.htm and search for "Compare" http://www.cpearson.com/Zips/Compare.ZIP -- Regards Frank Kabel Frankfurt, Germany "spbaechle" schrieb im Newsbeitrag ... I have a spreadsheet list of names, addresses, phone numbers, & 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. |
#8
|
|||
|
|||
Gregg,
Let me know if you figure out how to do this. Susie "gdtatuiowa" wrote: Bernie, I'm a newbie, but I have just spent the last hour searching for a tool to compare workbooks when I found this recent post, and your response. You instructed the poster to contact you privately for your compare add-in. I do not know how to contact you privately. Your e-mail address for the newsgroup appears to be a false address (judging by the name). Please, if possible, send me your private contact information at my (real) e-mail address, which is . I would like to receive, and to try to use, your developed add-in, if at all possible. Thanks in advance for your reply. Gregg Terrell Applications Developer University of Iowa Iowa City,IA "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. |
#9
|
|||
|
|||
Gregg,
Just sent. Check your inbox. HTH, Bernie MS Excel MVP "gdtatuiowa" wrote in message ... Bernie, I'm a newbie, but I have just spent the last hour searching for a tool to compare workbooks when I found this recent post, and your response. You instructed the poster to contact you privately for your compare add-in. I do not know how to contact you privately. Your e-mail address for the newsgroup appears to be a false address (judging by the name). Please, if possible, send me your private contact information at my (real) e-mail address, which is . I would like to receive, and to try to use, your developed add-in, if at all possible. Thanks in advance for your reply. Gregg Terrell Applications Developer University of Iowa Iowa City,IA "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. |
#10
|
|||
|
|||
OK I hit reply, but I do not see your e-mail address. Mine is my display
name at juno dot com. "Bernie Deitrick" wrote: 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. |
#11
|
|||
|
|||
Hi
you have to enable macros -- Regards Frank Kabel Frankfurt, Germany "spbaechle" schrieb im Newsbeitrag ... I downloaded Compare.zip, but I can't figure out how to open it. It says it is a macro, but then the button says "disable macros" and when I click enter to get the default options it doesn't open it. What am I doing wrong? Or, what should I be doing? Sorry I don't understand this stuff. "Frank Kabel" wrote: Hi goto: http://www.cpearson.com/excel/download.htm and search for "Compare" http://www.cpearson.com/Zips/Compare.ZIP -- Regards Frank Kabel Frankfurt, Germany "spbaechle" schrieb im Newsbeitrag ... I have a spreadsheet list of names, addresses, phone numbers, & 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. |
#12
|
|||
|
|||
Bernie, could you send me that add-in. TIA
Greg "spbaechle" wrote in message ... OK I hit reply, but I do not see your e-mail address. Mine is my display name at juno dot com. "Bernie Deitrick" wrote: 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, & 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
Where can I find advanced info on Excel Charts? | Charts and Charting in Excel | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) | |||
boolean find criteria in Excel | Excel Discussion (Misc queries) | |||
Viewing Excel spreadsheets | Excel Discussion (Misc queries) |