Hello!
Here's what I've been tasked with:
I'm setting up a spreadsheet to track invoices. I have 2 tabs. The first tab records the Purchase Order Number, Supplier, terms, the amount of the PO and a few other items. The second tab tracks invoices. What I hope to accomplish is this: When a user enters the invoice info - they will also enter what PO number the invoice should be applied to. I want to set up a column 'Balance of Invoice' on the first tab that will automatically look at the list of invoices and subtract if the POs match. I'm thinking Index, match will work but I need assistance. Any feedback is greatly appreciated. thank you
Here's what I've been tasked with:
I'm setting up a spreadsheet to track invoices. I have 2 tabs. The first tab records the Purchase Order Number, Supplier, terms, the amount of the PO and a few other items. The second tab tracks invoices. What I hope to accomplish is this: When a user enters the invoice info - they will also enter what PO number the invoice should be applied to. I want to set up a column 'Balance of Invoice' on the first tab that will automatically look at the list of invoices and subtract if the POs match. I'm thinking Index, match will work but I need assistance. Any feedback is greatly appreciated. thank you