+ Reply to Thread
Results 1 to 3 of 3

Macro to Compare Two Worksheets?

Hybrid View

  1. #1
    V. Hatherley
    Guest

    RE: Macro to Compare Two Worksheets?

    I forgot to mention that there are more than a few cases where the same part
    number appears twice or even three times on one report, each time with a
    different size. When this happens, the third worksheet should show each
    non-matching iteration of the part number with the sizes that didn't match.
    (It can just show the same number and ID info on multiple lines, each line
    with a different size.)

    Does this make sense? I'm leaving my desk for awhile go cry.

    "V. Hatherley" wrote:

    > I'm having a bit of a Saturday crisis. I have two very large reports (a few
    > thousand lines each), each one on a different sheet of the same workbook.
    > Each report has many columns, including the following four:
    >
    > PART NUMBER
    > PRODUCT NAME
    > PRODUCT SIZE
    > PRODUCT SERIES
    >
    > We've become aware that the product size for each part varies between the
    > two reports. My boss, a coworker, and I have started correllating the reports
    > by hand to see which sizes vary and by how much. Even sorting them to the
    > max, this will take DAYS.
    >
    > Is there a macro that will compare the part numbers on each sheet and show
    > only the ones whose size varies on a third worksheet? This third worksheet
    > would have five columns: the part number, product name, product series,
    > product size as shown on worksheet 1 and product size as shown on worksheet
    > 2. Products whose sizes were the same between the two reports would not
    > appear.
    >
    > To complicate matters, one report is much larger thah the other, so many
    > parts may not have matches at all. When this happens, the third worksheet
    > should show the same ID info as if there were a match, but simply return "NO
    > MATCH" as the value.
    >
    > Sigh. I know thiat is advanced stuff that really my company should pay for,
    > but they won't and I'm stuck. Could anyone please help?


  2. #2
    Jim Cone
    Guest

    Re: Macro to Compare Two Worksheets?

    A commercial program alternative from yours truly has a free trial offer.
    Maybe that will get you off the hook. Look for XL Companion at...
    http://www.realezsites.com/bus/primitivesoftware

    And maybe your boss will like it enough to keep it around.
    --
    Jim Cone
    San Francisco, USA


    "V. Hatherley"
    <vhatherley@discussions.microsoft.com>
    wrote in message
    I forgot to mention that there are more than a few cases where the same part
    number appears twice or even three times on one report, each time with a
    different size. When this happens, the third worksheet should show each
    non-matching iteration of the part number with the sizes that didn't match.
    (It can just show the same number and ID info on multiple lines, each line
    with a different size.)

    Does this make sense? I'm leaving my desk for awhile go cry.

    "V. Hatherley" wrote:

    > I'm having a bit of a Saturday crisis. I have two very large reports (a few
    > thousand lines each), each one on a different sheet of the same workbook.
    > Each report has many columns, including the following four:
    >
    > PART NUMBER
    > PRODUCT NAME
    > PRODUCT SIZE
    > PRODUCT SERIES
    >
    > We've become aware that the product size for each part varies between the
    > two reports. My boss, a coworker, and I have started correllating the reports
    > by hand to see which sizes vary and by how much. Even sorting them to the
    > max, this will take DAYS.
    >
    > Is there a macro that will compare the part numbers on each sheet and show
    > only the ones whose size varies on a third worksheet? This third worksheet
    > would have five columns: the part number, product name, product series,
    > product size as shown on worksheet 1 and product size as shown on worksheet
    > 2. Products whose sizes were the same between the two reports would not
    > appear.
    >
    > To complicate matters, one report is much larger thah the other, so many
    > parts may not have matches at all. When this happens, the third worksheet
    > should show the same ID info as if there were a match, but simply return "NO
    > MATCH" as the value.
    >
    > Sigh. I know thiat is advanced stuff that really my company should pay for,
    > but they won't and I'm stuck. Could anyone please help?


+ 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