+ Reply to Thread
Results 1 to 8 of 8

Create report compareing 2 Sheets

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Create report compareing 2 Sheets

    If you run a macro, stored in your Personal.xlsb, on the sheets, it does not care about what version the sheets are so long as their names are the same, e.g., sheet1 and sheet2.

  2. #2
    Registered User
    Join Date
    04-27-2009
    Location
    Bahrain
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Create report compareing 2 Sheets

    The sheets to be compared have different names daily. I always compare today with yesterday, for examle (sheetnames: 120509 and 110509)
    I am able to locate the sheets with the names of todays and yesterday dates.
    But how do i do the marcro to find who is in sheet1 and not in sheet2 and who is in sheet2 but not in sheet1?
    I can only find macros that search for dublicates, but that does not help me.

+ Reply to Thread

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