Retrive information from one excel document and create a new document from form

[Daun]

Hello,

This is my first time posting on this forum so I will try to explain as well as my english allows me to do

Ok, I'm sitting here with document "A", which is a excel document that is a Long, long list of companies forgotten payments.

And document "B" which is a form that I want to paste in for example Company name, adress in certain places....

Ok so far it should not be to difficult, but here comes the tricky part.

Document "A"s list is as follows.


Column A: Customer number (it says DL00 in front of every no which I do not want to copy)
Column B: Company name
Column C: invoice number
Column D: Penelty cost
Column E: Date when invoice should have been paid
Column F: Date when it was paid
Column G: C/O
Column H: Street adress
Column I: ZIP
Column J: City


What I would like to do is as follows;
1) I want to copy the custumernumber to Document "B" in A:8 with the DL00 cut out and Customer no: put in front of it

2) I want G,H,I,J and B put in to different spaces

3) I want everyone with the same customer number put in to the same document and put the cost of invoice 11111 to be put in A10 and the cost of invoice 22222 to be put in space A11...
So that I do not create 10 different documents for one company

4) I would like it to create a document for every company with the name of the company as the document name.

*Phew* ok this might be imposible I seriously have no Idea because programming in excel is not a strong side of mine :/

Thank you for your time.

[royUK]

Can't you use a PivotTable?

[Daun]

Can't you use a PivotTable?

Not a bad Idea, but I have tried that but because of the fact that there are so many lines it does not seem to work.
To much data to handle I believe. there are like 700 companies so its not a small amount.

The other problem is when there is a company with several different invoices I need them to be typed in different rows and I cant get that to work either.

I need it to do this; If there is only 1 invoice its no problem it can type that one in the form that I can then print, BUt when the samt company has 2 or more invoices that need to be retrieved I need it to type every invoice number on a different row with its penelty cost beside it.



Ive been sitting here and trying but I can not seem to get it to work..

[royUK]

Can you attach a small example workbook?

[Daun]

I will do that as soon as my computer starts working again

[Daun]

Can you attach a small example workbook?

I havent got it working yet but because of my skills in this kinde of work it really doesnt say much