+ Reply to Thread
Results 1 to 5 of 5

Exception report

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exception report

    Good afternoon,
    Having issues, I am trying to create an exception report that will spit out the differences between two reports on two different tabs,
    The items I need to match are Reporting number, transaction Code (PD and IT), date, Principal and Interest from Cash ledger tab to Inquiry end of day run tab.

    Thank you in advance.
    Mel
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Exception report

    Hi ALHASAN

    Welcome to the Forum!!

    Where do you wish the exceptions to be output? I see you have an Exception Sheet...should they go there?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Exception report

    Hi ALHASAN

    This Code in the attached assumes CASH LEDGER is the First Tab in the Workbook and that INQUIRY END OF DAY is the second Tab of the Workbook.

    The Code merely flags the exceptions.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-20-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Exception report

    Not working, but thanks

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Exception report

    Hi ALHASAN

    What does this mean???
    Not working
    Did you run the Code on your sample File? Do you get an error? Results are not as expected?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hi, I would like to automate a process for processing an exception report
    By paynegaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 07:12 PM
  2. Replies: 0
    Last Post: 04-04-2013, 10:23 PM
  3. Exception Report - Excel 2010
    By Kasell in forum Excel General
    Replies: 0
    Last Post: 08-09-2011, 12:27 PM
  4. Auto-generate an exception report
    By hrhr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2009, 02:05 AM
  5. [SOLVED] Exception report in excel
    By jj in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2005, 02:06 PM

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