compare worksheets

[klafert]

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.

 

[Paul B]

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]

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.

 

[klafert]

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]

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?

 

[PY & Associates]

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

 

[Jim Cone]

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...
(e-mail address removed) (remove the xxx).
Please include some explanatory info.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"klafert" <[email protected]>
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?