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.
Bookmarks