compare two documents

  1. B

    Vba To find unmatched Data in two workbooks

    Ok so i have looked and looked and looked but cant come up with anything on the internet. So now I turn to you. What i need to do is compare two different workbooks to find the unmatched info in Workbook A. Example of WorkBook A <colgroup><col width="64" span="4" style="width:48pt">...
  2. G

    Combining only like data from two seperate files

    I have two excel files. One is with a client information that I am trying to compare against the second file of our overall book of business. Our book of business has 3500 lines the client file has 1500 lines. I only want to combine side by side the lines that are the same from both files...
  3. G

    Compare two workbooks and find differences

    We have a need to compare two workbooks, which have identical structures, to determine which names have been added and which have been removed. Each workbook has multiple sheets which would need to be compared. Any suggestions would be greatly appreciated!
  4. C

    Need Help with creating a Macro for Comparing Purposes

    Not sure how to start on this so I'm just jumping in... This is a work-related issue that I am trying to find a quicker/automated way to do quality checks on reports we generate that can be utilized by multiple team members. Current Process: A client sends us an Excel Spreadsheet...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...