Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IS there a way to compare 2 excel files
I like to be able to compare 2 excel files to see how different they are.Is
there such a thing? |
#2
|
|||
|
|||
Hi
Now imagine how totally different two excel files can possibly be. The report would say ... ? But if you have two pretty similar sheets, try Myrna Larson and Bill Manville's "Compare", downloadable from http://www.cpearson.com/excel/download.htm HTH. Best wishes Harald "PeterM" skrev i melding ... I like to be able to compare 2 excel files to see how different they are.Is there such a thing? |
#3
|
|||
|
|||
Many thanks Harald.......I tell you what my problem is, I have 2 or 3 Excel
files on my pocket pc, that are in native excel document form. I keep forgetting which file I wrote my last information to. SO I thought if there was a brilliant person that could write a program, which I would buy, that would allow me to see the difference, maybe highlighted, between the 2 sheets............I downloaded the item you mentioned, but can not see anything. I changed my security macro level, to allow the enabling of macro's and still can't see anything when I ex ecute the file. Any additional help would be very much appreciated again. I appreciate you a lot Harald..............Peter "Harald Staff" wrote in message ... Hi Now imagine how totally different two excel files can possibly be. The report would say ... ? But if you have two pretty similar sheets, try Myrna Larson and Bill Manville's "Compare", downloadable from http://www.cpearson.com/excel/download.htm HTH. Best wishes Harald "PeterM" skrev i melding ... I like to be able to compare 2 excel files to see how different they are.Is there such a thing? |
#4
|
|||
|
|||
After you load Bill and Myrna's program (and your files),
click on Tools|Compare Worksheets Another option (maybe)... Save your files as .csv files. Then use MSWord to compare the .csv files. pmaston wrote: Many thanks Harald.......I tell you what my problem is, I have 2 or 3 Excel files on my pocket pc, that are in native excel document form. I keep forgetting which file I wrote my last information to. SO I thought if there was a brilliant person that could write a program, which I would buy, that would allow me to see the difference, maybe highlighted, between the 2 sheets............I downloaded the item you mentioned, but can not see anything. I changed my security macro level, to allow the enabling of macro's and still can't see anything when I ex ecute the file. Any additional help would be very much appreciated again. I appreciate you a lot Harald..............Peter "Harald Staff" wrote in message ... Hi Now imagine how totally different two excel files can possibly be. The report would say ... ? But if you have two pretty similar sheets, try Myrna Larson and Bill Manville's "Compare", downloadable from http://www.cpearson.com/excel/download.htm HTH. Best wishes Harald "PeterM" skrev i melding ... I like to be able to compare 2 excel files to see how different they are.Is there such a thing? -- Dave Peterson |
#5
|
|||
|
|||
Dave...........many many thanks, this is very much
appreciated...........Peter "Dave Peterson" wrote in message ... After you load Bill and Myrna's program (and your files), click on Tools|Compare Worksheets Another option (maybe)... Save your files as .csv files. Then use MSWord to compare the .csv files. pmaston wrote: Many thanks Harald.......I tell you what my problem is, I have 2 or 3 Excel files on my pocket pc, that are in native excel document form. I keep forgetting which file I wrote my last information to. SO I thought if there was a brilliant person that could write a program, which I would buy, that would allow me to see the difference, maybe highlighted, between the 2 sheets............I downloaded the item you mentioned, but can not see anything. I changed my security macro level, to allow the enabling of macro's and still can't see anything when I ex ecute the file. Any additional help would be very much appreciated again. I appreciate you a lot Harald..............Peter "Harald Staff" wrote in message ... Hi Now imagine how totally different two excel files can possibly be. The report would say ... ? But if you have two pretty similar sheets, try Myrna Larson and Bill Manville's "Compare", downloadable from http://www.cpearson.com/excel/download.htm HTH. Best wishes Harald "PeterM" skrev i melding ... I like to be able to compare 2 excel files to see how different they are.Is there such a thing? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloading Files Using Excel | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Linking Excel files -- I cannot find an answer anywhere. | Excel Discussion (Misc queries) | |||
Using large excel files | Excel Worksheet Functions | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |