werra2006
03-21-2013, 01:45 AM
Hi I'm still a newbie in this business so please be patient. I have a Sales workbook which has 2 worksheets namely: Invoice & Balances
1) Worksheet Invoices has the detail of all invoices raised by the company. The invoices are run as a batch & each invoice will have multiple lines per invoice number.
2) Worksheet Balances has the summary of outstanding invoices (ie Batch total ONLY without the indidual lines per invoice). What can happen is that an invoice might have 5 different lines but a customer might only pay for 3 different lines hence the invoice will still reflect as outstanding but only with an amount for the 2 unpaid lines; summarised under one line.
What I want to do is to create an extra tab; Balances detail worksheet. I want to lookup in Balances worksheet, column A with invoice numbers, then match to the detailed Invoices worksheet also in column A. If invoices are found matching i want then to copy the whole rows to the created Balances detail worksheet.
1) Worksheet Invoices has the detail of all invoices raised by the company. The invoices are run as a batch & each invoice will have multiple lines per invoice number.
2) Worksheet Balances has the summary of outstanding invoices (ie Batch total ONLY without the indidual lines per invoice). What can happen is that an invoice might have 5 different lines but a customer might only pay for 3 different lines hence the invoice will still reflect as outstanding but only with an amount for the 2 unpaid lines; summarised under one line.
What I want to do is to create an extra tab; Balances detail worksheet. I want to lookup in Balances worksheet, column A with invoice numbers, then match to the detailed Invoices worksheet also in column A. If invoices are found matching i want then to copy the whole rows to the created Balances detail worksheet.