tag:blogger.com,1999:blog-4545163587452304025.post6695257710968828461..comments2023-10-24T10:54:02.185+03:00Comments on Dieg's world: How to Compare Two Spreadsheets in ExcelDieghttp://www.blogger.com/profile/15977769850127757216noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4545163587452304025.post-55885963295127671302014-07-29T01:28:50.598+03:002014-07-29T01:28:50.598+03:00An easier way is to change the font color of one s...An easier way is to change the font color of one spreadsheet before copying and pasting it into spreadsheet two. Sort and remove duplicates. Not only do you get a quick comparison but you also identify the location of differences without an additional comparison. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-52791128508178703532013-11-19T22:46:45.146+02:002013-11-19T22:46:45.146+02:00The code is not complete: "AskSheet" is ...The code is not complete: "AskSheet" is not defined and the whole 'Ask for two sheets to compare' is incomplete and does not work as posted. Don't waste your time with this one.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-57845648661362417202013-04-11T00:26:55.215+03:002013-04-11T00:26:55.215+03:00I copy both sheets into one new sheet & use th...I copy both sheets into one new sheet & use the remove duplicates function on the combined sheet. All that remains are single entries for the non duplicated data.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-28701317851953786802012-09-29T02:12:09.183+02:002012-09-29T02:12:09.183+02:00good idea but also getting object required error o...good idea but also getting object required error on SelectSheet.SheetNames.Clear<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-40013770990976992402012-09-17T21:58:32.545+03:002012-09-17T21:58:32.545+03:00This looks very helpful and just what i need. Howe...This looks very helpful and just what i need. However, I am getting the following error code on :<br /><br />Compile Error: Ambiguous name detected: LeaveOnlyDifferent<br /><br />Would appreciate your helpAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-57292879294395193442012-08-03T19:05:04.665+03:002012-08-03T19:05:04.665+03:00I get an 'Object required' error on: Sele...I get an 'Object required' error on: SelectSheet.SheetNames.Clear<br /> in the first routine.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4545163587452304025.post-63030635501331933432012-08-03T01:34:57.251+03:002012-08-03T01:34:57.251+03:00How do I create the macro & function? Googling...How do I create the macro & function? Googling only tells me to enable the Developer tab, and use the Macro Recorder.<br /><br />Baffled.......Anonymousnoreply@blogger.com