Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Compare Sheets (Office 97 SR2)

    I have two almost identical spreadsheets, the only difference is in two of the colums, is there any way I can select just the rows which include the differences, <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    If you are a fool at forty, you will always be a fool

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compare Sheets (Office 97 SR2)

    It's not clear what you want to do about the differences. If you want to compare them, search here in the Excel Forum on 'compare' AND 'cells'.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare Sheets (Office 97 SR2)

    I you want to select the whole row where there are differences, then that will probably take a macro and we would need some additional information. Are these two worksheets in the same workbook or in different workbooks?. What is the column or columns where you want to check for differences. What are the worksheet names? On which workbook do you want to select the rows, or do you want to select them on both worksheets?

    If you just want to select a cell on the row where there is a difference, then you can enter a formula like the one below in an empty column on one of the sheets:

    <pre>=IF(A1<>Sheet2!A1,NA(),"")
    </pre>


    then fill that formual down as far as there are rows to check. That should put a #NA in that column in each row where there are differences. The select GoTo from the Edit menu and click on the Special button in the dialog box. In this dialog box, click on Formulas, and then unselect everything by "Errors" and click on OK. That should select all of the cells with the #NA in them.
    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Compare Sheets (Office 97 SR2)

    Hi Legare thanks for your response
    These are two seperate workbooks that are price lists
    But for some reason the italians can't tell us which prices have increased!!! there for I have to compare the old price list with the new
    Please see attachment
    Attached Files Attached Files
    If you are a fool at forty, you will always be a fool

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare Sheets (Office 97 SR2)

    Since I don't know if you have PKZIP, and I Can't attach two files to the same message, I am attaching one workbook to this message and a second to a reply to this message that show how I would do this. I had to convert the Lira Gross column from text to numeric values.
    Attached Files Attached Files
    Legare Coleman

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare Sheets (Office 97 SR2)

    Here is the second file.
    Attached Files Attached Files
    Legare Coleman

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Compare Sheets (Office 97 SR2)

    Hi Legare

    It worked fine, Once again thank you very much.
    Braddy60 <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    If you are a fool at forty, you will always be a fool

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare Sheets (Office 97 SR2)

    I use a similar technique from time to time:
    0) Right-click toolbars, Customize, Commands (tab), Edit (Categories). The next-to-last button in the Commands list is Select Visible Cells. Add that button to a toobar of your choice.
    1) Apply the formula, as Legare describes.
    2) Apply AutoFilter (Data menu, Filter, AutoFilter).
    3) In the column that contains the formula, filter on #N/A.
    4) Select the range you want (for example, if you don't want to select whole rows) - At this point, even the hidden rows are selected.
    5) Click the Select Visible Cells button
    6) Copy and paste them wherever you want, or do whatever else you want to/with them.

Posting Permissions

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