+ Reply to Thread
Results 1 to 1 of 1

Identifying UNPAID amounts between Paid documents and Unpaid Documents

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    Bulacan, Philippines
    MS-Off Ver
    MS office 2013
    Posts
    1

    Identifying UNPAID amounts between Paid documents and Unpaid Documents

    Hello I am a newbie here and I really hope someone will see this and help me with my problem

    Here is my Problem
    I have 2 Excel files (came from a PDF file) it was named PAID2016 and UNPAID2016. The 2 files contains records for unpaid and paid expenses with a SPECIFIC Receipt number which can be found to each documents BUT IT MAY NOT BE FOUND on the PAID2016 if the amount was still not settled.

    Here is what I am told to do and I don't have any idea how to start with since I was only doing a favor for a friend.
    1.) I need to merge PAID2016 and UNPAID2016 in 1
    2.) After merging I need to know WHAT PAYMENTS ARE STILL UNPAID. Based on the Receipt number referrence
    3.) TOTAL of that unpaid payments

    That's all I need.. I really don't know how to start and I dont wanna ruin the files . Thank you in advance.
    Attached Files Attached Files

+ 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. [SOLVED] Need to Mod Code on red text, I have VBA to distinguish Paid(Black Text) Unpaid(Red Text)
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2014, 07:55 PM
  2. [SOLVED] I need a VBA to distinguish Paid(Black Text) Unpaid(Red Text)
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-22-2013, 09:49 AM
  3. unpaid Invoices
    By hasanbirol in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-17-2012, 12:16 PM
  4. how to compute for the unpaid break
    By gerard_gonzales33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2012, 05:18 AM
  5. How to count unpaid installments.
    By rushatiindia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2008, 01:42 AM
  6. Paid vs Unpaid
    By ems.payroll in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-03-2008, 04:50 PM
  7. track unpaid invoices
    By mukesh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2006, 09:40 PM
  8. macro for unpaid rent
    By constance in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 10:06 AM

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