Senior Member
Reputation: 491
Excel compare tool
Dears ,
Do you know/ have smart tool that could compare between two excel files?
For example: to comapre the diference between Today and Yesterday cell stats
2011-02-17 07:23 PM
# ADS
Circuit advertisement
Re: Excel compare tool
Originally Posted by
justdream
Dears ,
Do you know/ have smart tool that could compare between two excel files?
For example: to comapre the diference between Today and Yesterday cell stats
A properly engineered "Macro" should do the trick. Is it not working for you?
Senior Member
Reputation: 491
Re: Excel compare tool
Please share if you have one..
Thanks
Re: Excel compare tool
simple macro can do it you can use Vlookup to put the parameter for each cell and simple if condition can do the Action
Member
Reputation: 71
Re: Excel compare tool
Hey Budy,
Try Synkronizer. It is a tool (Add-in) to be used with Excel. It is very useful, it compares two excell files and highlight the differences.
I think you can find it in the internet.
BR,
Attached Files
Post Thanks - 2 Thanks
Re: Excel compare tool
Hello Friends,
You could try these tool which works so well though it seems like it was built for ALU platform.
Let me know how it goes.
as always no password....just do the right thing by giving Rep or thanks if it is useful
Attached Files
Member
Reputation: 238
Re: Excel compare tool
Hi all
this was found on net and would like to share the same
Paste the sheets to compare in sheet1 and sheet2 ,Note headings same!!
after that run the macro.
Regards
Plannerguy
Attached Files
Post Thanks - 2 Thanks
Senior Member
Reputation: 491
Re: Excel compare tool
Originally Posted by
plannerguy
Hi all
this was found on net and would like to share the same
Paste the sheets to compare in sheet1 and sheet2 ,Note headings same!!
after that run the macro.
Regards
Plannerguy
this one is not smart enough. if you have changed the order of your cells - tool will consider it as different values (i.e tools compare based on rows orders; doesn't do vlookup)
Last edited by justdream; 2011-08-09 at 02:38 AM
Senior Member
Reputation: 491
Re: Excel compare tool
Originally Posted by
apollo13
Hey Budy,
Try Synkronizer. It is a tool (Add-in) to be used with Excel. It is very useful, it compares two excell files and highlight the differences.
I think you can find it in the internet.
BR,
Dear, this tool is limited to 30 days (what do you think )
also, tools shows only different values without keeping cell names & column header !!!
Senior Member
Reputation: 491
Re: Excel compare tool
Dears,
Do you know solution to let Sunkronizr add-ins be full (above attached one is trial version)
Bookmarks