Results 1 to 6 of 6

Comparing Tables

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,062

    Comparing Tables

    I need a macro to compare two 3-column tables having the same information in similar formats. I've attached a spreadsheet of the two tables. They originally come from two other spreadsheets, and i could run the routine either from those other two spreadsheets or on the sheet I've attached.

    The first run of this is going to be the hardest, as I'm trying to sync up data from two different reporting mechanisms, and we've been working to get the naming conventions right, but I'm sure there are errors I'll have to clean up. But after this, there will be a weekly comparison of the Number of FTEs, and so a weekly opportunity to be able to boil out any differences, which I would like to paste to another sheet in the same or a different workbook.

    I appreciate any help you can provide.

    Thanks,
    John
    Attached Files Attached Files
    Last edited by Mordred; 08-30-2011 at 12:59 PM. Reason: Attachment didn't take

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1