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.

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.

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.

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.

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.

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.

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.