If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
compare worksheets
I have a report I exported out of an accounting program into excel for 2
different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#2
|
|||
|
|||
compare worksheets
klafert, Have a look at the compare addin by Bill Manville & Myrna Larson
You can get a copy of it at Chip Pearson's page here, look for Compare http://www.cpearson.com/excel/download.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#3
|
|||
|
|||
compare worksheets
I got the program - now struggling now to read the worksheet it creates. Is
it possible for me to send you both spreadsheet and you can interrupt it for me? I know it is asking a lot. I am still checking it out to interrrupt it myself. "Paul B" wrote: klafert, Have a look at the compare addin by Bill Manville & Myrna Larson You can get a copy of it at Chip Pearson's page here, look for Compare http://www.cpearson.com/excel/download.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#4
|
|||
|
|||
compare worksheets
I am not postive but I think I have something going. First of all I narrowed
down what I am comparing to one field and can use VLookup to get the results but no a 100% yet. "klafert" wrote: I got the program - now struggling now to read the worksheet it creates. Is it possible for me to send you both spreadsheet and you can interrupt it for me? I know it is asking a lot. I am still checking it out to interrrupt it myself. "Paul B" wrote: klafert, Have a look at the compare addin by Bill Manville & Myrna Larson You can get a copy of it at Chip Pearson's page here, look for Compare http://www.cpearson.com/excel/download.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#5
|
|||
|
|||
compare worksheets
this helps but no cigar - because it found the 1st instance something is
wrong and since the lines number of the spreadsheets arent the same then there are itmes that arent really missing or wrong but shows up that way. Need a better soultions that compares the data such as reference number and not nost line to line data. Thanks anyway, anymore ideals? "klafert" wrote: I am not postive but I think I have something going. First of all I narrowed down what I am comparing to one field and can use VLookup to get the results but no a 100% yet. "klafert" wrote: I got the program - now struggling now to read the worksheet it creates. Is it possible for me to send you both spreadsheet and you can interrupt it for me? I know it is asking a lot. I am still checking it out to interrrupt it myself. "Paul B" wrote: klafert, Have a look at the compare addin by Bill Manville & Myrna Larson You can get a copy of it at Chip Pearson's page here, look for Compare http://www.cpearson.com/excel/download.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#6
|
|||
|
|||
compare worksheets
A crude DIY approach:
modify column labels to suit column M = col A & col B & col C.... continue until sufficient to make line unique column N = "Old-" & row() Replace "Old-" with "New-" and do the same in new file stack both columns; sort by col M; work from bottom up, delete paired rows == missing entries -- Regards "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#7
|
|||
|
|||
compare worksheets
k,
If you are still having a problem with it, I am curious to see what I can do with my XL Companion program. I can run the match lists feature (one column vs. the other column) to identify common and mismatched items in each column. Identical cell order is not required. Common items are colored yellow and mismatched items are colored gray. Then I can run a row check to find mismatched rows. (cell order matters here, but not row order) If interested, virus check the files again and send them to... XX (remove the xxx). Please include some explanatory info. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "klafert" wrote in message ... this helps but no cigar - because it found the 1st instance something is wrong and since the lines number of the spreadsheets arent the same then there are itmes that arent really missing or wrong but shows up that way. Need a better soultions that compares the data such as reference number and not nost line to line data. Thanks anyway, anymore ideals? "klafert" wrote: I am not postive but I think I have something going. First of all I narrowed down what I am comparing to one field and can use VLookup to get the results but no a 100% yet. "klafert" wrote: I got the program - now struggling now to read the worksheet it creates. Is it possible for me to send you both spreadsheet and you can interrupt it for me? I know it is asking a lot. I am still checking it out to interrrupt it myself. "Paul B" wrote: klafert, Have a look at the compare addin by Bill Manville & Myrna Larson You can get a copy of it at Chip Pearson's page here, look for Compare http://www.cpearson.com/excel/download.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "klafert" wrote in message ... I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
Thread Tools | |
Display Modes | |
|
|