Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Harrow, UK
    Posts
    53

    Unanswered: Comparing two spreadsheets

    I receive a spreadsheet each day.
    At the top it has some header rows and a logo.
    At the bottom there are some footer rows, some blank rows and a logo.

    What I want to do is compare the spreadsheet to the previous days, and create a list of rows that have changed or which are new.

    Where do I begin?
    Thank you,
    James

  2. #2
    Join Date
    Aug 2003
    Posts
    15

    Re: Comparing two spreadsheets

    build a macro in a seperate spreadsheet that will set spreadsheet1.row1 = spreadsheet2.row1. that field will return true or false.Build a macro loop that checks each row until the end of the document. all falses are changes or new.

  3. #3
    Join Date
    Jul 2003
    Location
    Harrow, UK
    Posts
    53

    Re: Comparing two spreadsheets

    Originally posted by microgenius
    build a macro in a seperate spreadsheet that will set spreadsheet1.row1 = spreadsheet2.row1. that field will return true or false.Build a macro loop that checks each row until the end of the document. all falses are changes or new.
    Thanks for this, although it's a bit more complicated than that. New can can be inserted anywhere - not just at the end. So I need to strip off the headers and logos and then sort, then compare.

    So I'm still stuggling with this.
    Thank you,
    James

Posting Permissions

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