Results 1 to 3 of 3

Compare two spreadsheets and report only those items that are new on the sheet.

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Tokyo, Japan
    MS-Off Ver
    Office 2007
    Posts
    26

    Compare two spreadsheets and report only those items that are new on the sheet.

    I have a list of lessons booked each day, with a cut of of scheduling or cancelling those lessons by 3 PM the day before the lesson. For example, customers could book a lesson on Friday for Sunday or Monday, but could cancel either the day before prior to the cut off.

    I want to prepare a sheet of the lessons booked for Sunday and Monday in a check Friday evening. I would provide this list to staff Friday evening. They would add a similar sheet to the book showing the same list, but including any changed to the list. They would generate this sheet after the 3 PM cut off.

    I need the workbook to compare the list from Friday, to the list on Saturday and Sunday to either show a condition if the lesson is new or to show only the new lessons. This way staff would only have to check the new items. The list generally runs 70-120 lessons, but new would likely only be 2-10 lessons.

    Cancelled meetings are no issue, as they do not show on the list. Only confirmed, life links/lessons. Ideally, if this can simply show in the original new sheet with a lookup or if statement and conditional formatting, great. But I am not adverse to using a VBA routine to create a new sheet listing only the new items, or a userform.

    I have listed only the Friday and Saturday check of the Sunday schedule, but I would need to be able to do the same for Monday, figuring I can apply the same logic to the next day (Friday check vs. Sunday check).

    Thanks in advance for your efforts and ideas!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two spreadsheets and updates sheet 1 with data from sheet 2
    By Josling in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 07:26 AM
  2. Compare items from 2 spreadsheets
    By jemory in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2012, 08:22 AM
  3. VBA Macro to compare time sheet data and build report.
    By manonfire32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2012, 09:58 PM
  4. Macro to compare items from 2 sheets in III sheet
    By TRJJK73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2008, 02:42 PM
  5. [SOLVED] Compare data of two excel spreadsheets in a third sheet
    By Hanson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2006, 12:55 PM
  6. Compare records in multiple sheet -> report
    By PB in forum Excel General
    Replies: 3
    Last Post: 07-04-2005, 01:05 PM
  7. Compare records in multiple sheet -> report
    By PB in forum Excel General
    Replies: 1
    Last Post: 07-04-2005, 08:05 AM

Tags for this Thread

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