Hi, I have multiple excel sheets with information about daily invoices that need to be copied to a master creditors file only if that invoice is not paid. In that file we record the daily collection details also. So if it is under the heading of Credit collection, then those invoice numbers should be deleted from the master credits file. Below is a sample of how the excel file. If you want I can attach a dummy file. Date: 12-12-1990 Payment Details Invoice No. Customer name Amount Pmnt Dtls Pymnt dtls Pymnt dtls pymnt dtls Paid Credit 10 Example Customer 200 200 11 Ex customer 2 1000 1000 12 Ex customer 250 100 150 Credit Collection 3 Ex customer 250 250 Now I understand that this might become very complex so if you can help me with the copying of only the daily credit invoices that would be also very good. Thanks in advance

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy from multiple workbooks to one work book.

Thread starter alimmv
Start date May 16, 2018
Tags

credit customer dtls file invoice

alimmv

New Member

May 16, 2018

Hi,

I have multiple excel sheets with information about daily invoices that need to be copied to a master creditors file only if that invoice is not paid. In that file we record the daily collection details also. So if it is under the heading of Credit collection, then those invoice numbers should be deleted from the master credits file. Below is a sample of how the excel file. If you want I can attach a dummy file.

Date:	12-12-1990		Payment Details
Invoice No.	Customer name	Amount	Pmnt Dtls	Pymnt dtls	Pymnt dtls	pymnt dtls	Paid	Credit
10	Example Customer	200					200
11	Ex customer 2	1000						1000
12	Ex customer	250					100	150

Credit Collection
3	Ex customer	250					250

Now I understand that this might become very complex so if you can help me with the copying of only the daily credit invoices that would be also very good.

Thanks in advance