Thanks Thanks:  22
Page 1 of 2 12 LastLast
Showing results 1 to 10 of 13

Thread: Excel compare tool

  1. #1
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,954


    Default 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

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Member Reputation: 256
    Join Date
    2008-11-24
    Location
    North of Wall
    Posts
    216


    Default Re: Excel compare tool

    Quote Originally Posted by justdream View Post
    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?

  4. #3
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,954


    Default Re: Excel compare tool

    Please share if you have one..
    Thanks

  5. #4
    Reputation: 2
    Join Date
    2010-11-17
    Posts
    8


    Default 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

  6. #5
    Member Reputation: 71
    Join Date
    2009-04-27
    Location
    Many Places
    Posts
    108


    Default 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 Attached Files

  7. Thanks alfahd, kevin_h811 thanked for this post
  8. #6
    Member Reputation: 304
    Join Date
    2009-02-12
    Posts
    449


    Default 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 Attached Files

  9. #7
    Member Reputation: 238
    Join Date
    2009-01-20
    Posts
    539


    Default 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 Attached Files

  10. Thanks alfahd, kevin_h811 thanked for this post
  11. #8
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,954


    Default Re: Excel compare tool

    Quote Originally Posted by plannerguy View Post
    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

  12. #9
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,954


    Default Re: Excel compare tool

    Quote Originally Posted by apollo13 View Post
    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 !!!

  13. #10
    Senior Member Reputation: 491
    Join Date
    2008-08-14
    Posts
    2,954


    Default Re: Excel compare tool

    Dears,

    Do you know solution to let Sunkronizr add-ins be full (above attached one is trial version)

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •