On Sheet1(Labled Income) I have invoices set-up as follows:
Colums:
A Dates B Invoice#s C Amounts D Paid-Y/N E Customer Names
On Sheet3 (Labled Oustanding Customers) I want to list all invoices from "Income" that are marked "no" on the D Colum. can anyone help me out please!
For example if my Invoiced read as follows on Sheet1 (Labled Income):
Date Invoice# Amount Paid-Y/N Customer Name
3/22/2011 1000 30.00 yes aaa
3/23/2011 1001 50.00 no bbb
I want to list the following on Sheet3 (Labled Outstanding Costumers:
3/23/2011 1001 50.00 bbb
Please Help!
Bookmarks